explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hEu0

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3,869.354 ↑ 2.1 197 1

Finalize GroupAggregate (cost=1,189,040.23..1,189,325.98 rows=422 width=40) (actual time=3,868.902..3,869.354 rows=197 loops=1)

  • Group Key: "BSC6900GSM@GSM Cell@KPI"."Date
  • Functions: 189
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 33.412 ms, Inlining 390.714 ms, Optimization 2851.549 ms, Emission 1777.263 ms, Total 5052.939 ms
2. 660.072 4,465.809 ↑ 1.8 1,182 1

Gather Merge (cost=1,189,040.23..1,189,295.38 rows=2,110 width=40) (actual time=3,868.852..4,465.809 rows=1,182 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
3. 0.153 3,805.737 ↑ 2.1 197 6 / 6

Sort (cost=1,188,040.16..1,188,041.21 rows=422 width=40) (actual time=3,805.720..3,805.737 rows=197 loops=6)

  • Sort Key: "BSC6900GSM@GSM Cell@KPI"."Date
  • Sort Method: quicksort Memory: 40kB
  • Worker 0: Sort Method: quicksort Memory: 40kB
  • Worker 1: Sort Method: quicksort Memory: 40kB
  • Worker 2: Sort Method: quicksort Memory: 40kB
  • Worker 3: Sort Method: quicksort Memory: 40kB
  • Worker 4: Sort Method: quicksort Memory: 40kB
4. 59.833 3,805.584 ↑ 2.1 197 6 / 6

Partial HashAggregate (cost=1,188,017.53..1,188,021.75 rows=422 width=40) (actual time=3,805.530..3,805.584 rows=197 loops=6)

  • Group Key: "BSC6900GSM@GSM Cell@KPI"."Date
5. 222.547 3,745.751 ↑ 1.2 243,621 6 / 6

Parallel Hash Left Join (cost=984,338.39..1,184,396.55 rows=289,679 width=40) (actual time=3,098.621..3,745.751 rows=243,621 loops=6)

  • Hash Cond: (("BSC6900GSM@GSM Cell@KPI"."Object Name" = "BSC6900GSM@GSM Cell@Outgoing_External_Inter-Cell_Handover"."Object Name") AND ("BSC6900GSM@GSM Cell@KPI"."Result Time" = "BSC6900GSM@GSM Cell@Outgoing_External_Inter-Cell_Handover"."Result Time"))
6. 221.817 1,482.670 ↑ 1.2 243,621 6 / 6

Parallel Hash Left Join (cost=411,202.74..609,740.08 rows=289,679 width=112) (actual time=1,051.232..1,482.670 rows=243,621 loops=6)

  • Hash Cond: (("BSC6900GSM@GSM Cell@KPI"."Object Name" = "BSC6900GSM@GSM Cell@Outgoing_Internal_Inter-Cell_Handover"."Object Name") AND ("BSC6900GSM@GSM Cell@KPI"."Result Time" = "BSC6900GSM@GSM Cell@Outgoing_Internal_Inter-Cell_Handover"."Result Time"))
7. 221.469 222.063 ↑ 1.2 243,621 6 / 6

Parallel Bitmap Heap Scan on "BSC6900GSM@GSM Cell@KPI" (cost=417.86..197,434.39 rows=289,679 width=96) (actual time=4.201..222.063 rows=243,621 loops=6)

  • Recheck Cond: (("Date" >= '2020-01-01 00:00:00'::timestamp without time zone) AND ("Date" < '2021-01-01 00:00:00'::timestamp without time zone))
  • Rows Removed by Index Recheck: 759
  • Heap Blocks: lossy=16,953
8. 0.594 0.594 ↑ 1.6 919,040 1 / 6

Bitmap Index Scan on "BSC6900GSM_GSM_Cell_KPI_Date" (cost=0.00..55.76 rows=1,453,843 width=0) (actual time=3.561..3.561 rows=919,040 loops=1)

  • Index Cond: (("Date" >= '2020-01-01 00:00:00'::timestamp without time zone) AND ("Date" < '2021-01-01 00:00:00'::timestamp without time zone))
9. 509.978 1,038.790 ↑ 1.0 467,866 6 / 6

Parallel Hash (cost=403,766.75..403,766.75 rows=467,875 width=104) (actual time=1,038.790..1,038.790 rows=467,866 loops=6)

  • Buckets: 4,194,304 Batches: 1 Memory Usage: 415,552kB
10. 528.812 528.812 ↑ 1.0 467,866 6 / 6

Parallel Seq Scan on "BSC6900GSM@GSM Cell@Outgoing_Internal_Inter-Cell_Handover" (cost=0.00..403,766.75 rows=467,875 width=104) (actual time=0.161..528.812 rows=467,866 loops=6)

11. 488.063 2,040.534 ↑ 1.0 467,866 6 / 6

Parallel Hash (cost=566,117.66..566,117.66 rows=467,866 width=104) (actual time=2,040.534..2,040.534 rows=467,866 loops=6)

  • Buckets: 4,194,304 Batches: 1 Memory Usage: 415,584kB
12. 1,552.471 1,552.471 ↑ 1.0 467,866 6 / 6

Parallel Seq Scan on "BSC6900GSM@GSM Cell@Outgoing_External_Inter-Cell_Handover" (cost=0.00..566,117.66 rows=467,866 width=104) (actual time=837.768..1,552.471 rows=467,866 loops=6)

Execution time : 4,472.237 ms