explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LCUJ

Settings
# exclusive inclusive rows x rows loops node
1. 13.394 5,621.648 ↑ 1.0 1 1

Aggregate (cost=1,867,927.34..1,867,927.35 rows=1 width=8) (actual time=5,621.648..5,621.648 rows=1 loops=1)

  • Functions: 24
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 3.459 ms, Inlining 17.950 ms, Optimization 113.785 ms, Emission 83.102 ms, Total 218.297 ms
2. 25.979 5,608.254 ↓ 2.0 196,742 1

Nested Loop (cost=20.79..1,867,684.79 rows=97,022 width=0) (actual time=5,283.598..5,608.254 rows=196,742 loops=1)

3. 168.954 168.954 ↑ 1.0 1 1

Index Scan using api_rule_pkey on api_rule (cost=0.28..8.29 rows=1 width=4) (actual time=168.952..168.954 rows=1 loops=1)

  • Index Cond: (id = 1101)
  • Filter: active
4. 5,366.877 5,413.321 ↓ 2.0 196,742 1

Index Only Scan using reports_denormal_acrs_index on reports_denormal (cost=20.51..1,866,706.27 rows=97,022 width=4) (actual time=5,114.642..5,413.321 rows=196,742 loops=1)

  • Index Cond: ((account = '729650'::text) AND (rule_id = 1101))
  • Filter: (NOT (hashed SubPlan 1))
  • Heap Fetches: 0
5.          

SubPlan (for Index Only Scan)

6. 46.444 46.444 ↑ 1.0 355 1

Seq Scan on api_ack u2 (cost=0.00..19.05 rows=355 width=4) (actual time=46.287..46.444 rows=355 loops=1)

  • Filter: ((account)::text = '729650'::text)
  • Rows Removed by Filter: 529
Planning time : 0.318 ms
Execution time : 5,624.324 ms