explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aic3

Settings
# exclusive inclusive rows x rows loops node
1. 162,089.745 178,019.323 ↑ 1.0 1 1

Aggregate (cost=2,006,508.14..2,006,508.15 rows=1 width=8) (actual time=178,019.322..178,019.323 rows=1 loops=1)

2. 15,928.416 15,929.578 ↓ 1.3 23,981,911 1

Index Only Scan using api_report_a_c_s_r_index on api_report (cost=179.46..1,960,959.16 rows=18,219,594 width=20) (actual time=1.333..15,929.578 rows=23,981,911 loops=1)

  • Index Cond: ((account = '729650'::text) AND (checked_on >= '2019-01-01 00:00:00'::timestamp without time zone) AND (checked_on <= '2019-08-01 23:59:59'::timestamp without time zone))
  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 12354481
  • Heap Fetches: 0
3.          

SubPlan (for Index Only Scan)

4. 1.162 1.162 ↑ 1.0 107 1

Seq Scan on api_rule (cost=0.00..178.49 rows=107 width=4) (actual time=0.016..1.162 rows=107 loops=1)

  • Filter: (NOT active)
  • Rows Removed by Filter: 942
Planning time : 0.374 ms
Execution time : 178,019.402 ms