explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P4pX

Settings
# exclusive inclusive rows x rows loops node
1. 20.530 793.710 ↓ 9.3 164,981 1

Unique (cost=94,915.00..95,048.31 rows=17,775 width=8) (actual time=758.028..793.710 rows=164,981 loops=1)

2. 52.119 773.180 ↓ 9.4 166,479 1

Sort (cost=94,915.00..94,959.44 rows=17,775 width=8) (actual time=758.027..773.180 rows=166,479 loops=1)

  • Sort Key: o.create_date DESC, o.object_id DESC
  • Sort Method: quicksort Memory: 13948kB
3. 225.681 721.061 ↓ 9.4 166,479 1

Hash Join (cost=41,781.49..93,660.30 rows=17,775 width=8) (actual time=244.678..721.061 rows=166,479 loops=1)

  • Hash Cond: ((o.object_id)::integer = (i.object_id)::integer)
4. 250.934 250.934 ↑ 1.0 1,488,833 1

Seq Scan on objects o (cost=0.00..45,557.07 rows=1,563,026 width=8) (actual time=0.007..250.934 rows=1,488,833 loops=1)

  • Filter: ((inactive)::integer = 0)
  • Rows Removed by Filter: 66511
5. 22.365 244.446 ↓ 3.7 176,108 1

Hash (cost=41,182.47..41,182.47 rows=47,922 width=8) (actual time=244.446..244.446 rows=176,108 loops=1)

  • Buckets: 262144 (originally 65536) Batches: 1 (originally 1) Memory Usage: 8928kB
6. 111.374 222.081 ↓ 3.7 176,108 1

Hash Join (cost=23,130.99..41,182.47 rows=47,922 width=8) (actual time=125.821..222.081 rows=176,108 loops=1)

  • Hash Cond: ((m.element_id)::integer = (i.object_id)::integer)
  • -> Bitmap Heap Scan on matches m (cost=3184.04..20113.16 rows=171504 width=4) (actual time=14.534..52.529 rows=176237 l
  • Recheck Cond: ((parent_id)::integer = ANY ('{5,6,7,8,25,307865,310990,562540,586570,1328125,1403430,1403433,194982,
  • Heap Blocks: exact=11565
  • -> Bitmap Index Scan on matches_pkey (cost=0.00..3141.16 rows=171504 width=0) (actual time=13.277..13.277 rows=17
  • Index Cond: ((parent_id)::integer = ANY ('{5,6,7,8,25,307865,310990,562540,586570,1328125,1403430,1403433,194
7. 30.082 110.707 ↑ 1.0 175,356 1

Hash (cost=17,752.92..17,752.92 rows=175,522 width=4) (actual time=110.707..110.707 rows=175,356 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 8213kB
8. 80.625 80.625 ↑ 1.0 175,356 1

Seq Scan on img i (cost=0.00..17,752.92 rows=175,522 width=4) (actual time=0.008..80.625 rows=175,356 loops=1)

  • Filter: ((x_block_nfstart)::smallint = 0)
  • Rows Removed by Filter: 111