Amazon RDS instances have slow query logging disabled by default. Here is how to enable slow query logging and access the slow query data on your RDS instance using the RDS command-line tools:

1. Install the Amazon RDS command-line tools and configure your environment according to the documentation: http://aws.amazon.com/developertools/2928
2. Create a parameter group:
   $ rds-create-db-parameter-group sweet-parameter-group -f mysql5.1 -d "This is a totally sweet database parameter group"
3. Place your DB instance in that parameter group:
   $ rds-modify-db-instance my-instance --db-parameter-group-name sweet-parameter-group --apply-immediately
4. Modify the parameter group to turn on slow query logging:
   $ rds-modify-db-parameter-group sweet-parameter-group --parameters "name=slow_query_log, value=ON, method=immediate" --parameters "name=long_query_time, value=1, method=immediate" --parameters "name=min_examined_row_limit, value=100, method=immediate"

   If you like, you can verify that your settings were made properly:
   $ rds-describe-db-parameters sweet-parameter-group

5. Reboot your DB instance:
   $ rds-reboot-db-instance my-instance

After following the above steps, you will be able to access the slow query log by querying the mysql.slow_log table.