explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j3rN

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 8,721.706 ↓ 0.0 0 1

Merge Join (cost=523,704.75..523,741.36 rows=684 width=34) (actual time=8,721.705..8,721.706 rows=0 loops=1)

  • Merge Cond: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_1.geo_value)::text)
2. 0.000 8,721.704 ↓ 0.0 0 1

Sort (cost=261,703.89..261,709.08 rows=2,076 width=26) (actual time=8,721.704..8,721.704 rows=0 loops=1)

  • Sort Key: huawei_lte_cell_dly.geo_value
  • Sort Method: quicksort Memory: 25kB
3. 63.349 8,770.053 ↓ 0.0 0 1

Gather (cost=1,000.00..261,589.51 rows=2,076 width=26) (actual time=8,721.672..8,770.053 rows=0 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
4. 8,706.704 8,706.704 ↓ 0.0 0 6

Parallel Seq Scan on huawei_lte_cell_dly (cost=0.00..260,381.91 rows=415 width=26) (actual time=8,706.704..8,706.704 rows=0 loops=6)

  • Filter: ((formula_code = 575) AND ((date_time)::date = '2019-06-09'::date))
  • Rows Removed by Filter: 3169469
5. 0.000 0.000 ↓ 0.0 0

Sort (cost=262,000.86..262,010.55 rows=3,878 width=18) (never executed)

  • Sort Key: huawei_lte_cell_dly_1.geo_value
6. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..261,769.71 rows=3,878 width=18) (never executed)

  • Workers Planned: 5
  • Workers Launched: 0
7. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on huawei_lte_cell_dly huawei_lte_cell_dly_1 (cost=0.00..260,381.91 rows=776 width=18) (never executed)

  • Filter: ((formula_code = 450) AND ((date_time)::date = '2019-06-09'::date))