explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bIrx

Settings
# exclusive inclusive rows x rows loops node
1. 2.046 417.386 ↑ 1.0 1 1

Aggregate (cost=1,480,940.04..1,480,940.05 rows=1 width=8) (actual time=417.386..417.386 rows=1 loops=1)

  • Functions: 67
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 7.211 ms, Inlining 124.493 ms, Optimization 248.326 ms, Emission 162.154 ms, Total 542.184 ms
2. 0.000 415.340 ↓ 7.4 19,762 1

Nested Loop (cost=1,021.22..1,480,933.39 rows=2,658 width=0) (actual time=153.798..415.340 rows=19,762 loops=1)

3. 120.947 120.947 ↑ 1.0 1 1

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

  • Index Cond: (id = 1101)
  • Filter: active
4. 26.342 296.197 ↓ 7.4 19,762 1

Gather (cost=1,020.94..1,480,898.52 rows=2,658 width=4) (actual time=32.850..296.197 rows=19,762 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 259.716 269.855 ↓ 5.9 6,587 3

Nested Loop (cost=20.94..1,479,632.72 rows=1,108 width=4) (actual time=139.638..269.855 rows=6,587 loops=3)

6. 10.132 10.132 ↑ 2.2 22,729 3

Parallel Index Only Scan using api_upload_account_system_uuid_source_id_id_index on api_upload (cost=0.43..5,051.67 rows=49,830 width=4) (actual time=0.044..10.132 rows=22,729 loops=3)

  • Index Cond: (account = '729650'::text)
  • Heap Fetches: 0
7. 0.000 0.007 ↓ 0.0 0 68,188

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

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

SubPlan (for Index Only Scan)

9. 43.419 43.419 ↑ 1.0 355 3

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

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