explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m6qN

Settings
# exclusive inclusive rows x rows loops node
1. 603.271 10,023.535 ↑ 4.8 5,052,081 1

Gather Motion 8:1 (slice1; segments: 8) (cost=0.00..15,859.57 rows=24,214,441 width=38) (actual time=6,075.681..10,023.535 rows=5,052,081 loops=1)

  • (slice0) Executor memory: 456K bytes.
  • (slice1) Executor memory: 122,484K bytes avg x 8 workers, 123508K bytes max (seg0). Work_mem: 53,390K bytes max. Memory used: 128,000kB Optimizer: Pivotal Optimizer (GPORCA) version 3.65.0
2. 101.367 9,420.264 ↑ 4.8 632,713 1

Result (cost=0.00..13,308.46 rows=3,026,806 width=38) (actual time=6,191.666..9,420.264 rows=632,713 loops=1)

3. 1,641.196 9,318.897 ↑ 4.8 632,713 1

Hash Semi Join (cost=0.00..13,193.44 rows=3,026,806 width=30) (actual time=6,191.661..9,318.897 rows=632,713 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,489.422 1,489.422 ↓ 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.034..1,489.422 rows=5,402,602 loops=1)

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

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

6. 100.334 5,920.748 ↑ 2.2 1,366,765 1

Result (cost=0.00..9,272.63 rows=3,026,806 width=8) (actual time=0.919..5,920.748 rows=1,366,765 loops=1)

7. 5,820.414 5,820.414 ↑ 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.917..5,820.414 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 : 103.692 ms
Execution time : 10,187.626 ms