explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wBj

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

Nested Loop (cost=10.67..8,085.85 rows=1 width=34) (actual time=0.020..0.020 rows=0 loops=1)

  • Join Filter: ((qr.id_qr_client)::text = (qc.id_qr_client)::text)
2. 0.000 0.019 ↓ 0.0 0 1

Nested Loop (cost=10.67..8,072.04 rows=28 width=38) (actual time=0.019..0.019 rows=0 loops=1)

3. 0.019 0.019 ↓ 0.0 0 1

Index Only Scan using spare_mass_prod_part_pk on spare_mass_prod_part smpp (cost=0.42..4.60 rows=9 width=11) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (id_root_part = 'F'::text)
  • Filter: ((id_mass_prod_part)::text <> 'ZZTOP'::text)
  • Heap Fetches: 0
4. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on qr (cost=10.25..896.35 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[]))
5. 0.000 0.000 ↓ 0.0 0

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

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

Materialize (cost=0.00..12.97 rows=2 width=4) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Seq Scan on qr_client qc (cost=0.00..12.96 rows=2 width=4) (never executed)

  • Filter: (qr_client_type = 'E'::bpchar)
Planning time : 1.570 ms