explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oTiH

Settings
# exclusive inclusive rows x rows loops node
1. 53,747.855 296,181.359 ↓ 1.5 5,482,675 1

Hash Join (cost=7,153,975.32..10,180,041.14 rows=3,726,618 width=92) (actual time=94,271.284..296,181.359 rows=5,482,675 loops=1)

  • Hash Cond: (r.id = ro.rpi_id)
  • Buffers: shared hit=18,877,519 dirtied=8,687
2. 148,184.802 148,184.802 ↑ 1.0 61,945,872 1

Seq Scan on rpi r (cost=0.00..2,802,527.19 rows=62,265,493 width=30) (actual time=0.046..148,184.802 rows=61,945,872 loops=1)

  • Filter: (type = 2)
  • Rows Removed by Filter: 30,597,278
  • Buffers: shared hit=1,642,266 dirtied=8,687
3. 7,049.620 94,248.702 ↓ 1.9 10,087,124 1

Hash (cost=7,089,284.82..7,089,284.82 rows=5,175,240 width=8) (actual time=94,248.701..94,248.702 rows=10,087,124 loops=1)

  • Buckets: 16,777,216 (originally 8388608) Batches: 1 (originally 1) Memory Usage: 525,101kB
  • Buffers: shared hit=17,235,253
4. 27,514.852 87,199.082 ↓ 1.9 10,087,124 1

HashAggregate (cost=7,037,532.42..7,089,284.82 rows=5,175,240 width=8) (actual time=78,971.591..87,199.082 rows=10,087,124 loops=1)

  • Group Key: ro.rpi_id
  • Buffers: shared hit=17,235,253
5. 59,684.230 59,684.230 ↓ 1.1 16,025,803 1

Index Scan using idx_rpi_operation_operation_date on rpi_operation ro (cost=0.57..7,000,728.42 rows=14,721,599 width=8) (actual time=0.075..59,684.230 rows=16,025,803 loops=1)

  • Index Cond: ((operation_date >= '2018-11-01 00:00:00+03'::timestamp with time zone) AND (operation_date <= '2018-12-01 00:00:00+03'::timestamp with time zone))
  • Filter: (type_id = 8)
  • Rows Removed by Filter: 81,821,394
  • Buffers: shared hit=17,235,253
Planning time : 0.650 ms
Execution time : 296,872.763 ms