explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vxSS

Settings
# exclusive inclusive rows x rows loops node
1. 8.185 36.264 ↑ 1.3 14,846 1

Merge Left Join (cost=3,748.94..4,146.96 rows=19,013 width=627) (actual time=24.518..36.264 rows=14,846 loops=1)

  • Merge Cond: ((overview.activity_date = (timezone('asia/kuala_lumpur'::text, dor.operation_date))) AND ((overview.plant_field_name)::text = (dor.field)::text))
2. 10.353 24.074 ↑ 1.3 14,845 1

Sort (cost=3,607.40..3,654.93 rows=19,013 width=110) (actual time=20.853..24.074 rows=14,845 loops=1)

  • Sort Key: overview.activity_date, overview.plant_field_name
  • Sort Method: quicksort Memory: 3000kB
3. 13.721 13.721 ↑ 1.3 14,845 1

Seq Scan on activity_overview overview (cost=0.00..2,256.08 rows=19,013 width=110) (actual time=0.067..13.721 rows=14,845 loops=1)

  • Filter: ((activity_date >= '2019-01-01 00:00:00+08'::timestamp with time zone) AND (activity_date <= '2019-12-31 00:00:00+08'::timestamp with time zone) AND ((source)::text = ANY ('{AGDP,"PBOCC DOR",GDS,"GDS Draft"}'::text[])))
  • Rows Removed by Filter: 37709
4. 2.926 4.005 ↑ 1.0 1,775 1

Sort (cost=141.54..145.98 rows=1,775 width=19) (actual time=3.658..4.005 rows=1,775 loops=1)

  • Sort Key: (timezone('asia/kuala_lumpur'::text, dor.operation_date)), dor.field
  • Sort Method: quicksort Memory: 187kB
5. 1.079 1.079 ↑ 1.0 1,775 1

Seq Scan on dl_pbocc_dor dor (cost=0.00..45.75 rows=1,775 width=19) (actual time=0.010..1.079 rows=1,775 loops=1)

Planning time : 0.185 ms
Execution time : 38.994 ms