explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UWKt

Settings

Optimization(s) for this plan:

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

Nested Loop (cost=1,015.45..7,870.16 rows=1 width=34) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,015.18..7,869.56 rows=2 width=42) (actual rows= loops=)

  • Hash Cond: ((qr.id_qr_client)::text = (qcad.id_qr_client)::text)
3. 0.000 0.000 ↓ 0.0

Gather (cost=1,010.33..7,864.42 rows=30 width=38) (actual rows= loops=)

  • Workers Planned: 1
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10.33..6,861.42 rows=18 width=38) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on spare_mass_prod_part smpp (cost=0.00..2,183.04 rows=5 width=11) (actual rows= loops=)

  • Filter: ((id_root_part)::text = 'F'::text)
6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on qr (cost=10.33..935.65 rows=3 width=38) (actual rows= loops=)

  • Recheck Cond: ((id_part)::text = (smpp.id_mass_prod_part)::text)
  • Filter: (received_month = ANY ('{2012-09-01,2012-09-01,2012-09-01}'::date[]))
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on qr_id_part_i (cost=0.00..10.32 rows=235 width=0) (actual rows= loops=)

  • Index Cond: ((id_part)::text = (smpp.id_mass_prod_part)::text)
8. 0.000 0.000 ↓ 0.0

Hash (cost=4.79..4.79 rows=5 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on qr_client_ass_dpt qcad (cost=0.00..4.79 rows=5 width=4) (actual rows= loops=)

  • Filter: ((id_assembly_dept)::text = ANY ('{1,2,3}'::text[]))
10. 0.000 0.000 ↓ 0.0

Index Scan using qr_client_pk on qr_client qc (cost=0.28..0.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((id_qr_client)::text = (qr.id_qr_client)::text)