explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xec4

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.149 ↓ 0.0 0 1

Nested Loop (cost=11.15..8,400.41 rows=1 width=34) (actual time=0.149..0.149 rows=0 loops=1)

2. 0.000 0.148 ↓ 0.0 0 1

Nested Loop (cost=11.00..8,400.19 rows=1 width=42) (actual time=0.148..0.148 rows=0 loops=1)

  • Join Filter: ((qr.id_qr_client)::text = (qc.id_qr_client)::text)
3. 0.148 0.148 ↓ 0.0 0 1

Index Scan using qr_client_pk on qr_client qc (cost=0.28..46.09 rows=3 width=4) (actual time=0.148..0.148 rows=0 loops=1)

  • Filter: (qr_client_type = 'E'::bpchar)
  • Rows Removed by Filter: 568
4. 0.000 0.000 ↓ 0.0 0

Materialize (cost=10.72..8,352.86 rows=29 width=38) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=10.72..8,352.72 rows=29 width=38) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Index Scan using spare_mass_prod_part_id_root_part_i on spare_mass_prod_part smpp (cost=0.42..37.08 rows=9 width=11) (never executed)

  • Index Cond: ((id_root_part)::text = 'F'::text)
7. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on qr (cost=10.30..923.93 rows=3 width=38) (never executed)

  • 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[]))
8. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on qr_id_part_i (cost=0.00..10.30 rows=232 width=0) (never executed)

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

Index Scan using idx_qr_client_ass on qr_client_ass_dpt qcad (cost=0.15..0.21 rows=1 width=20) (never executed)

  • Index Cond: ((id_qr_client)::text = (qr.id_qr_client)::text)
  • Filter: ((id_assembly_dept)::text = ANY ('{1,2,3}'::text[]))
Planning time : 1.372 ms
Execution time : 0.217 ms