explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CetZ

Settings
# exclusive inclusive rows x rows loops node
1. 522.358 10,231.427 ↑ 4.0 6,010,305 1

Gather Motion 8:1 (slice1; segments: 8) (cost=0.00..15,835.36 rows=24,214,441 width=38) (actual time=6,020.041..10,231.427 rows=6,010,305 loops=1)

  • (slice0) Executor memory: 456K bytes.
  • (slice1) Executor memory: 74,356K bytes avg x 8 workers, 74356K bytes max (seg0). Work_mem: 42,712K bytes max. Memory used: 128,000kB Optimizer: Pivotal Optimizer (GPORCA) version 3.65.0
2. 120.464 9,709.069 ↑ 4.0 752,613 1

Result (cost=0.00..13,284.25 rows=3,026,806 width=38) (actual time=6,424.212..9,709.069 rows=752,613 loops=1)

3. 1,703.625 9,588.605 ↑ 4.0 752,613 1

Hash Join (cost=0.00..13,169.23 rows=3,026,806 width=30) (actual time=6,424.206..9,588.605 rows=752,613 loops=1)

  • Hash Cond: (rpi.id = rpi_operation.rpi_id)
  • Extra Text: (seg3) Hash chain length 2.2 avg, 26 max, using 630713 of 1048576 buckets.
4. 1,465.813 1,465.813 ↓ 1.0 5,402,602 1

Seq Scan on rpi (cost=0.00..1,714.02 rows=5,397,168 width=30) (actual time=0.044..1,465.813 rows=5,402,602 loops=1)

  • Filter: (type = 2)
5. 333.038 6,419.167 ↑ 2.2 1,366,765 1

Hash (cost=9,248.42..9,248.42 rows=3,026,806 width=8) (actual time=6,419.167..6,419.167 rows=1,366,765 loops=1)

6. 6,086.129 6,086.129 ↑ 2.2 1,366,765 1

Seq Scan on rpi_operation (cost=0.00..9,248.42 rows=3,026,806 width=8) (actual time=0.880..6,086.129 rows=1,366,765 loops=1)

  • Filter: ((type_id = 8) AND (operation_date >= '2018-08-01 00:00:00+03'::timestamp with time zone) AND (operation_date <= '2018-10-01 00:00:00+03'::timestamp with time zone))
Planning time : 275.545 ms
Execution time : 10,408.115 ms