explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wawt

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=2,965,029.08..2,969,531.51 rows=175,845 width=4) (never executed)

2. 0.000 0.000 ↓ 0.0

Sort (cost=2,965,029.08..2,967,280.3 rows=900,486 width=4) (never executed)

  • Sort Key: people.source_item_id
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on qpq_item_statements people (cost=963,161.2..2,863,656.47 rows=900,486 width=4) (never executed)

4. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=963,161.2..963,161.2 rows=900,486 width=0) (never executed)

5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on qpq_item_statements_target_item_id_idx (cost=0..87,450.94 rows=4,735,249 width=0) (never executed)

  • Index Cond: (people.target_item_id = 5)
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on qpq_item_statements_edge_property_id_idx (cost=0..875,259.77 rows=47,394,027 width=0) (never executed)

  • Index Cond: (people.edge_property_id = 31)