explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IC4s

Settings
# exclusive inclusive rows x rows loops node
1. 45,646.424 407,779.589 ↓ 1.6 5,482,675 1

Hash Join (cost=7,204,604.75..10,185,030.53 rows=3,471,512 width=92) (actual time=308,466.285..407,779.589 rows=5,482,675 loops=1)

  • Hash Cond: (r.id = rpi_operation.rpi_id)
2. 53,737.735 53,737.735 ↑ 1.0 61,944,218 1

Seq Scan on rpi r (cost=0.00..2,799,781.42 rows=62,204,488 width=30) (actual time=0.082..53,737.735 rows=61,944,218 loops=1)

  • Filter: (type = 2)
  • Rows Removed by Filter: 30,585,877
3. 4,990.657 308,395.430 ↓ 1.9 10,087,124 1

Hash (cost=7,139,916.27..7,139,916.27 rows=5,175,079 width=8) (actual time=308,395.429..308,395.430 rows=10,087,124 loops=1)

  • Buckets: 16,777,216 (originally 8388608) Batches: 1 (originally 1) Memory Usage: 525,101kB
4. 21,030.144 303,404.773 ↓ 1.9 10,087,124 1

HashAggregate (cost=7,036,414.69..7,088,165.48 rows=5,175,079 width=8) (actual time=298,633.768..303,404.773 rows=10,087,124 loops=1)

  • Group Key: rpi_operation.rpi_id
5. 282,374.629 282,374.629 ↓ 1.1 16,025,803 1

Index Scan using idx_rpi_operation_operation_date on rpi_operation (cost=0.57..6,999,616.52 rows=14,719,268 width=8) (actual time=34.545..282,374.629 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.444 ms
Execution time : 408,661.307 ms