explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZF41

Settings
# exclusive inclusive rows x rows loops node
1. 8.313 4,716.009 ↓ 13.3 9,080 1

Merge Join (cost=523,704.75..523,741.36 rows=684 width=34) (actual time=4,705.602..4,716.009 rows=9,080 loops=1)

  • Merge Cond: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_1.geo_value)::text)
2. 35.941 2,403.225 ↓ 4.4 9,080 1

Sort (cost=261,703.89..261,709.08 rows=2,076 width=26) (actual time=2,402.250..2,403.225 rows=9,080 loops=1)

  • Sort Key: huawei_lte_cell_dly.geo_value
  • Sort Method: external sort Disk: 376kB
3. 1.638 2,367.284 ↓ 4.4 9,080 1

Gather (cost=1,000.00..261,589.51 rows=2,076 width=26) (actual time=2,344.992..2,367.284 rows=9,080 loops=1)

  • Workers Planned: 5
  • Workers Launched: 0
4. 2,365.646 2,365.646 ↓ 21.9 9,080 1

Parallel Seq Scan on huawei_lte_cell_dly (cost=0.00..260,381.91 rows=415 width=26) (actual time=2,344.729..2,365.646 rows=9,080 loops=1)

  • Filter: ((formula_code = 575) AND ((date_time)::date = '2019-06-08'::date))
  • Rows Removed by Filter: 19007734
5. 36.086 2,304.471 ↓ 2.3 9,080 1

Sort (cost=262,000.86..262,010.55 rows=3,878 width=18) (actual time=2,303.324..2,304.471 rows=9,080 loops=1)

  • Sort Key: huawei_lte_cell_dly_1.geo_value
  • Sort Method: external sort Disk: 296kB
6. 1.289 2,268.385 ↓ 2.3 9,080 1

Gather (cost=1,000.00..261,769.71 rows=3,878 width=18) (actual time=2,228.242..2,268.385 rows=9,080 loops=1)

  • Workers Planned: 5
  • Workers Launched: 0
7. 2,267.096 2,267.096 ↓ 11.7 9,080 1

Parallel Seq Scan on huawei_lte_cell_dly huawei_lte_cell_dly_1 (cost=0.00..260,381.91 rows=776 width=18) (actual time=2,227.960..2,267.096 rows=9,080 loops=1)

  • Filter: ((formula_code = 450) AND ((date_time)::date = '2019-06-08'::date))
  • Rows Removed by Filter: 19007734
Planning time : 1.022 ms
Execution time : 4,716.832 ms