explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j9LU

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

Gather (cost=0..0 rows=0 width=0) (actual rows=15 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.000 0.000 ↓ 0.0 5 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual rows=5 loops=3)

3. 0.000 0.000 ↓ 0.0 5,026,293 3 / 3

Seq Scan on policy_update_infos p1 (cost=0..0 rows=0 width=0) (actual rows=5,026,293 loops=3)

4. 0.000 0.000 ↓ 0.0 3 3 / 3

Hash (cost=0..0 rows=0 width=0) (actual rows=3 loops=3)

5. 0.000 0.000 ↓ 0.0 3 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual rows=3 loops=3)

6. 0.000 0.000 ↓ 0.0 2,464,793 3 / 3

Seq Scan on policies p0 (cost=0..0 rows=0 width=0) (actual rows=2,464,793 loops=3)

7. 0.000 0.000 ↓ 0.0 3 3 / 3

Hash (cost=0..0 rows=0 width=0) (actual rows=3 loops=3)

8. 0.000 0.000 ↓ 0.0 8 1 / 3

Bitmap Heap Scan on policy_update_infos p (cost=0..0 rows=0 width=0) (actual rows=8 loops=1)

  • Heap Blocks: exact=5
9. 0.000 0.000 ↓ 0.0 8 1 / 3

Bitmap Index Scan on ix_policy_update_infos_external_info_plate_number (cost=0..0 rows=0 width=0) (actual rows=8 loops=1)

  • Index Cond: ((external_info ->> 'PlateNumber'::text) = ANY ('{А924НХ198,Е475КО196,555D05977,М858ВК77}'::text[]))