explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gNHs

Settings
# exclusive inclusive rows x rows loops node
1. 128.737 43,748.731 ↑ 38,852.7 15 1

Gather (cost=791,176.91..1,998,579.55 rows=582,790 width=242) (actual time=43,632.385..43,748.731 rows=15 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=12,368 read=659,592, temp read=529,474 written=529,572
2. 17,298.192 43,619.994 ↑ 48,565.8 5 3 / 3

Hash Join (cost=790,176.91..1,939,300.55 rows=242,829 width=242) (actual time=39,463.917..43,619.994 rows=5 loops=3)

  • Buffers: shared hit=12,368 read=659,592, temp read=529,474 written=529,572
3. 21,611.053 21,611.053 ↑ 1.2 5,026,293 3 / 3

Seq Scan on policy_update_infos p1 (cost=0..660,774.66 rows=6,282,866 width=242) (actual time=5.399..21,611.053 rows=5,026,293 loops=3)

  • Buffers: shared hit=8,269 read=589,677
4. 0.928 4,710.749 ↑ 41,886.0 3 3 / 3

Hash (cost=787,624.19..787,624.19 rows=125,658 width=34) (actual time=4,710.748..4,710.749 rows=3 loops=3)

  • Buffers: shared hit=4,009 read=69,915, temp read=33,435 written=33,496
5. 2,449.016 4,709.821 ↑ 41,886.0 3 3 / 3

Hash Join (cost=609,334.31..787,624.19 rows=125,658 width=34) (actual time=4,212.94..4,709.821 rows=3 loops=3)

  • Buffers: shared hit=4,009 read=69,915, temp read=33,435 written=33,484
6. 2,260.411 2,260.411 ↑ 1.3 2,464,793 3 / 3

Seq Scan on policies p0 (cost=0..106,415.15 rows=3,251,215 width=17) (actual time=0.77..2,260.411 rows=2,464,793 loops=3)

  • Buffers: shared hit=3,988 read=69,915
7. 0.302 0.394 ↑ 41,886.0 3 3 / 3

Hash (cost=607,026.58..607,026.58 rows=125,658 width=17) (actual time=0.393..0.394 rows=3 loops=3)

  • Buffers: shared hit=21, temp written=12
8. 0.029 0.092 ↑ 15,707.2 8 1 / 3

Bitmap Heap Scan on policy_update_infos p (cost=6,919.45..607,026.58 rows=125,658 width=17) (actual time=0.213..0.275 rows=8 loops=1)

  • Heap Blocks: exact=5
  • Buffers: shared hit=21
9. 0.062 0.062 ↑ 37,697.2 8 1 / 3

Bitmap Index Scan on ix_policy_update_infos_external_info_plate_number (cost=0..6,844.06 rows=301,578 width=0) (actual time=0.187..0.187 rows=8 loops=1)

  • Index Cond: ((p.external_info ->> 'PlateNumber'::text) = ANY ('{А924НХ198,Е475КО196,555D05977,М858ВК77}'::text[]))
  • Buffers: shared hit=16
Planning time : 1.218 ms
Execution time : 43,748.984 ms