explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dDbw

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 1,697.743 ↑ 1.0 10 1

Limit (cost=0.56..1,200.75 rows=10 width=36) (actual time=723.274..1,697.743 rows=10 loops=1)

  • Output: data_item_id, ((sort_variables ->> 'pub_date'::text))
  • Buffers: shared hit=1,154,423
2. 1,697.708 1,697.708 ↑ 1,165.2 10 1

Index Scan using tiger_one_expr_idx on analytics.tiger_one (cost=0.56..1,398,459.71 rows=11,652 width=36) (actual time=723.261..1,697.708 rows=10 loops=1)

  • Output: data_item_id, (sort_variables ->> 'pub_date'::text)
  • Filter: ((tiger_one.entities @> '{6202}'::integer[]) AND (tiger_one.category = 9))
  • Rows Removed by Filter: 1,150,356
  • Buffers: shared hit=1,154,423
Planning time : 0.197 ms
Execution time : 1,697.787 ms