explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8pbT

Settings
# exclusive inclusive rows x rows loops node
1. 510.768 1,579.266 ↓ 1.7 1,286,969 1

Nested Loop (cost=1,643.46..19,794.94 rows=752,770 width=16) (actual time=34.810..1,579.266 rows=1,286,969 loops=1)

2. 55.909 61.866 ↓ 457.6 91,512 1

HashAggregate (cost=1,638.90..1,640.90 rows=200 width=16) (actual time=34.466..61.866 rows=91,512 loops=1)

  • Group Key: "VisibleItemInstances".id
3. 5.957 5.957 ↑ 1.0 91,512 1

Seq Scan on "VisibleItemInstances" (cost=0.00..1,410.12 rows=91,512 width=16) (actual time=0.008..5.957 rows=91,512 loops=1)

4. 640.584 1,006.632 ↑ 1.8 14 91,512

Bitmap Heap Scan on "ItemModuleInstance" imi (cost=4.56..90.52 rows=25 width=32) (actual time=0.009..0.011 rows=14 loops=91,512)

  • Recheck Cond: ("itemInstanceId" = "VisibleItemInstances".id)
  • Heap Blocks: exact=284367
5. 366.048 366.048 ↑ 1.8 14 91,512

Bitmap Index Scan on "ItemModuleInstance_itemInstanceId_ix" (cost=0.00..4.55 rows=25 width=0) (actual time=0.004..0.004 rows=14 loops=91,512)

  • Index Cond: ("itemInstanceId" = "VisibleItemInstances".id)
Planning time : 0.260 ms
Execution time : 1,604.886 ms