explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BjUy

Settings
# exclusive inclusive rows x rows loops node
1. 148,962.232 171,049.058 ↑ 1.0 1 1

Aggregate (cost=1,979,397.49..1,979,397.50 rows=1 width=8) (actual time=171,049.058..171,049.058 rows=1 loops=1)

2. 7,980.344 22,086.826 ↑ 1.3 23,981,911 1

Hash Join (cost=190.96..1,900,265.97 rows=31,652,608 width=20) (actual time=0.990..22,086.826 rows=23,981,911 loops=1)

  • Hash Cond: (api_report.rule_id = api_rule.id)
3. 14,105.549 14,105.549 ↓ 1.0 36,336,392 1

Index Only Scan using api_report_a_c_r_s_index on api_report (cost=0.70..1,807,175.98 rows=35,247,968 width=20) (actual time=0.051..14,105.549 rows=36,336,392 loops=1)

  • Index Cond: ((account = '729650'::text) AND (checked_on >= '2019-01-01 00:00:00+00'::timestamp with time zone) AND (checked_on <= '2019-08-01 23:59:59+00'::timestamp with time zone))
  • Heap Fetches: 0
4. 0.178 0.933 ↑ 1.0 942 1

Hash (cost=178.49..178.49 rows=942 width=4) (actual time=0.933..0.933 rows=942 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
5. 0.755 0.755 ↑ 1.0 942 1

Seq Scan on api_rule (cost=0.00..178.49 rows=942 width=4) (actual time=0.008..0.755 rows=942 loops=1)

  • Filter: active
  • Rows Removed by Filter: 107
Planning time : 0.460 ms
Execution time : 171,049.097 ms