explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DGFj

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 108.209 ↓ 0.0 0 1

Limit (cost=34,153.95..34,153.96 rows=1 width=8) (actual time=108.209..108.209 rows=0 loops=1)

2. 0.010 108.208 ↓ 0.0 0 1

Sort (cost=34,153.95..34,153.96 rows=1 width=8) (actual time=108.208..108.208 rows=0 loops=1)

  • Sort Key: fk_customer_message DESC
  • Sort Method: quicksort Memory: 25kB
3. 108.198 108.198 ↓ 0.0 0 1

Seq Scan on customer_message_placeholder_category_configuration (cost=0.00..34,153.94 rows=1 width=8) (actual time=108.198..108.198 rows=0 loops=1)

  • Filter: ((database_id = 7,362,321) AND (optional_placeholder_category = 'foobar'::text))
  • Rows Removed by Filter: 1,356,931
Planning time : 0.077 ms
Execution time : 108.230 ms