explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aboz

Settings
# exclusive inclusive rows x rows loops node
1. 122.479 926.689 ↓ 4.4 9,080 1

Gather (cost=1,000.00..261,589.51 rows=2,076 width=18) (actual time=814.307..926.689 rows=9,080 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
2. 804.210 804.210 ↓ 3.6 1,513 6

Parallel Seq Scan on huawei_lte_cell_dly (cost=0.00..260,381.91 rows=415 width=18) (actual time=797.273..804.210 rows=1,513 loops=6)

  • Filter: ((formula_code = 575) AND ((date_time)::date = '2019-06-08'::date))
  • Rows Removed by Filter: 3167956
Planning time : 0.146 ms
Execution time : 927.324 ms