explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hpkP

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 205,697.790 ↑ 1.0 1 1

Finalize Aggregate (cost=5,259,181.20..5,259,181.21 rows=1 width=8) (actual time=205,697.790..205,697.790 rows=1 loops=1)

2. 100.732 205,737.844 ↓ 1.5 3 1

Gather (cost=5,259,180.98..5,259,181.19 rows=2 width=8) (actual time=205,697.779..205,737.844 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.159 205,637.112 ↑ 1.0 1 3

Partial Aggregate (cost=5,258,180.98..5,258,180.99 rows=1 width=8) (actual time=205,637.112..205,637.112 rows=1 loops=3)

4. 205,495.197 205,636.953 ↑ 1,435,437.7 75 3

Nested Loop (cost=24.55..4,989,036.42 rows=107,657,827 width=0) (actual time=3,266.846..205,636.953 rows=75 loops=3)

5. 136.946 136.946 ↑ 1.2 42,682 3

Parallel Seq Scan on ids_ann_modif ids (cost=0.00..5,096.51 rows=53,061 width=4) (actual time=0.043..136.946 rows=42,682 loops=3)

  • Filter: (url IS NULL)
  • Rows Removed by Filter: 89999
6. 0.017 4.810 ↓ 0.0 0 128,046

Bitmap Heap Scan on vo_all_partition_bg vo (cost=24.55..73.64 rows=2,029 width=27) (actual time=4.810..4.810 rows=0 loops=128,046)

  • Recheck Cond: (ids_ann @> ARRAY[ids.id_ann])
  • Filter: (dead AND (id_pays = 'BG'::bpchar))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=63777
7. 4.793 4.793 ↑ 1,599.5 2 128,046

Bitmap Index Scan on vo_all_tmp_partition_bg_ids_ann_idx (cost=0.00..24.05 rows=3,199 width=0) (actual time=4.793..4.793 rows=2 loops=128,046)

  • Index Cond: (ids_ann @> ARRAY[ids.id_ann])
Planning time : 0.238 ms