explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s6Qv

Settings
# exclusive inclusive rows x rows loops node
1. 2.521 542.236 ↑ 1.0 1 1

Aggregate (cost=1,246,640.37..1,246,640.38 rows=1 width=8) (actual time=542.235..542.236 rows=1 loops=1)

  • Functions: 67
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 6.125 ms, Inlining 149.199 ms, Optimization 291.062 ms, Emission 199.798 ms, Total 646.185 ms
2. 0.000 539.715 ↓ 6.1 19,762 1

Nested Loop (cost=1,021.36..1,246,632.28 rows=3,239 width=0) (actual time=177.114..539.715 rows=19,762 loops=1)

3. 134.447 134.447 ↑ 1.0 1 1

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

  • Index Cond: (id = 1101)
  • Filter: active
4. 39.214 411.206 ↓ 6.1 19,762 1

Gather (cost=1,021.08..1,246,591.59 rows=3,239 width=4) (actual time=42.666..411.206 rows=19,762 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 339.088 371.992 ↓ 4.9 6,587 3

Nested Loop (cost=21.08..1,245,267.69 rows=1,350 width=4) (actual time=169.915..371.992 rows=6,587 loops=3)

6. 32.895 32.895 ↑ 2.2 22,729 3

Parallel Index Only Scan using api_upload_current_account_system_uuid_source_id_id_index on api_upload (cost=0.56..44,229.92 rows=49,832 width=4) (actual time=0.066..32.895 rows=22,729 loops=3)

  • Index Cond: ((current = true) AND (account = '729650'::text))
  • Heap Fetches: 21209
7. 0.000 0.009 ↓ 0.0 0 68,188

Index Only Scan using api_report_upload_id_rule_id_1a55a613_uniq on api_report (cost=20.51..27.69 rows=2 width=8) (actual time=0.009..0.009 rows=0 loops=68,188)

  • Index Cond: ((upload_id = api_upload.id) AND (rule_id = 1101))
  • Filter: (NOT (hashed SubPlan 1))
  • Heap Fetches: 0
8.          

SubPlan (forIndex Only Scan)

9. 43.758 43.758 ↑ 1.0 355 3

Seq Scan on api_ack u2 (cost=0.00..19.05 rows=355 width=4) (actual time=43.548..43.758 rows=355 loops=3)

  • Filter: ((account)::text = '729650'::text)
  • Rows Removed by Filter: 529
Planning time : 483.450 ms
Execution time : 553.862 ms