explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ACpo

Settings
# exclusive inclusive rows x rows loops node
1. 83,529.823 183,775.743 ↓ 1.8 10,087,124 1

Hash Join (cost=7,142,427.37..10,032,711.95 rows=5,555,373 width=92) (actual time=88,065.620..183,775.743 rows=10,087,124 loops=1)

  • Hash Cond: (r.id = ro.rpi_id)
2. 12,253.548 12,253.548 ↓ 1.0 92,417,931 1

Seq Scan on rpi r (cost=0.00..2,558,536.31 rows=92,254,431 width=30) (actual time=0.027..12,253.548 rows=92,417,931 loops=1)

3. 6,517.745 87,992.372 ↓ 1.9 10,087,124 1

Hash (cost=7,077,757.60..7,077,757.60 rows=5,173,581 width=8) (actual time=87,992.372..87,992.372 rows=10,087,124 loops=1)

  • Buckets: 16,777,216 (originally 8388608) Batches: 1 (originally 1) Memory Usage: 525,101kB
4. 25,337.244 81,474.627 ↓ 1.9 10,087,124 1

HashAggregate (cost=7,026,021.79..7,077,757.60 rows=5,173,581 width=8) (actual time=73,914.456..81,474.627 rows=10,087,124 loops=1)

  • Group Key: ro.rpi_id
5. 56,137.383 56,137.383 ↓ 1.1 16,025,803 1

Index Scan using idx_rpi_operation_operation_date on rpi_operation ro (cost=0.57..6,989,277.56 rows=14,697,694 width=8) (actual time=0.080..56,137.383 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
Planning time : 0.575 ms
Execution time : 184,739.797 ms