explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mptr

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 1,341.031 ↓ 0.0 0 1

Limit (cost=1,000.00..87,500.29 rows=1 width=119) (actual time=1,341.031..1,341.031 rows=0 loops=1)

  • Output: dt_sale, co_client, id_store_type, tmp_field, vl_sale, vl_amount, id_offer, ti_hour, id_cash, id_store, id_tpv, id_ticket, dt_sale_cab, co_card, co_section, co_family, co_product, co_supplier, co_family_sfa
  • Buffers: shared hit=74346
2. 63.176 1,341.029 ↓ 0.0 0 1

Gather (cost=1,000.00..87,500.29 rows=1 width=119) (actual time=1,341.029..1,341.029 rows=0 loops=1)

  • Output: dt_sale, co_client, id_store_type, tmp_field, vl_sale, vl_amount, id_offer, ti_hour, id_cash, id_store, id_tpv, id_ticket, dt_sale_cab, co_card, co_section, co_family, co_product, co_supplier, co_family_sfa
  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=74346
3. 1,277.853 1,277.853 ↓ 0.0 0 5 / 5

Parallel Seq Scan on staging.est_f_sup_cli_mon_sto_gse1590213345994_82_extendida (cost=0.00..86,500.18 rows=1 width=119) (actual time=1,277.853..1,277.853 rows=0 loops=5)

  • Output: dt_sale, co_client, id_store_type, tmp_field, vl_sale, vl_amount, id_offer, ti_hour, id_cash, id_store, id_tpv, id_ticket, dt_sale_cab, co_card, co_section, co_family, co_product, co_supplier, co_family_sfa
  • Filter: (est_f_sup_cli_mon_sto_gse1590213345994_82_extendida.tmp_field IS NULL)
  • Rows Removed by Filter: 994573
  • Buffers: shared hit=74070
  • Worker 0: actual time=1288.060..1288.060 rows=0 loops=1
  • Buffers: shared hit=18678
  • Worker 1: actual time=1256.399..1256.399 rows=0 loops=1
  • Buffers: shared hit=15075
  • Worker 2: actual time=1268.129..1268.129 rows=0 loops=1
  • Buffers: shared hit=12553
  • Worker 3: actual time=1256.450..1256.450 rows=0 loops=1
  • Buffers: shared hit=13091
Planning time : 0.204 ms
Execution time : 1,444.065 ms