explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BH76

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.195 ↑ 1.0 1 1

Limit (cost=0.57..4,058.26 rows=1 width=4) (actual time=0.194..0.195 rows=1 loops=1)

  • Buffers: shared hit=36
2. 0.001 0.194 ↑ 175,845.0 1 1

Unique (cost=0.57..713,524,634.62 rows=175,845 width=4) (actual time=0.194..0.194 rows=1 loops=1)

  • Buffers: shared hit=36
3. 0.193 0.193 ↑ 900,486.0 1 1

Index Scan using qpq_item_statements_source_item_id_idx on qpq_item_statements people (cost=0.57..713,522,383.41 rows=900,486 width=4) (actual time=0.193..0.193 rows=1 loops=1)

  • Filter: ((people.edge_property_id = 31) AND (people.target_item_id = 5))
  • Buffers: shared hit=36
Planning time : 0.093 ms
Execution time : 0.209 ms