explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u5FD

Settings
# exclusive inclusive rows x rows loops node
1. 4.402 11.670 ↓ 0.0 0 1

Gather (cost=1,010.53..7,848.75 rows=1 width=34) (actual time=11.670..11.670 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 0.001 7.268 ↓ 0.0 0 2

Nested Loop (cost=10.53..6,848.65 rows=1 width=34) (actual time=7.268..7.268 rows=0 loops=2)

3. 0.003 7.267 ↓ 0.0 0 2

Nested Loop (cost=10.25..6,843.92 rows=16 width=38) (actual time=7.267..7.267 rows=0 loops=2)

4. 7.264 7.264 ↓ 0.0 0 2

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

  • Filter: ((id_root_part)::text = 'F'::text)
  • Rows Removed by Filter: 73916
5. 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[]))
6. 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)
7. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((id_qr_client)::text = (qr.id_qr_client)::text)
  • Filter: (qr_client_type = 'E'::bpchar)
Planning time : 2.357 ms