explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nj1G

Settings
# exclusive inclusive rows x rows loops node
1. 2.233 23.550 ↑ 1.0 100 1

Limit (cost=1,006.14..8,969.66 rows=100 width=631) (actual time=10.961..23.550 rows=100 loops=1)

2. 0.000 21.317 ↑ 7,478,618.9 100 1

WindowAgg (cost=1,006.14..59,556,129,429.86 rows=747,861,888 width=631) (actual time=10.960..21.317 rows=100 loops=1)

3. 1.626 20.636 ↑ 7,404,573.1 101 1

Gather Merge (cost=1,006.14..15,446,354,342.91 rows=747,861,888 width=547) (actual time=10.763..20.636 rows=101 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 0.325 19.010 ↑ 4,073,321.8 108 2

Nested Loop Left Join (cost=6.13..15,362,218,880.50 rows=439,918,758 width=547) (actual time=0.444..9.505 rows=108 loops=2)

5. 1.115 16.298 ↑ 4,073,321.8 108 2

Nested Loop Left Join (cost=5.28..8,719,328,166.77 rows=439,918,758 width=523) (actual time=0.355..8.149 rows=108 loops=2)

  • Join Filter: (dc."DataErrorID" = err."DataErrorID")
  • Rows Removed by Join Filter: 868
6. 0.340 14.532 ↑ 4,073,321.8 108 2

Nested Loop (cost=5.28..8,200,224,032.33 rows=439,918,758 width=392) (actual time=0.334..7.266 rows=108 loops=2)

7. 1.116 12.884 ↑ 4,035,951.9 109 2

Nested Loop Left Join (cost=4.72..4,469,432,216.07 rows=439,918,758 width=318) (actual time=0.277..6.442 rows=109 loops=2)

8. 0.356 3.920 ↑ 4,035,951.9 109 2

Nested Loop (cost=1.28..3,845,297,474.72 rows=439,918,758 width=60) (actual time=0.098..1.960 rows=109 loops=2)

9. 0.294 0.294 ↑ 4,035,951.9 109 2

Parallel Index Scan Backward using "PolicyEvents_idx4" on "PolicyEvents" pe (cost=0.57..44,369,432.80 rows=439,918,758 width=40) (actual time=0.028..0.147 rows=109 loops=2)

10. 3.270 3.270 ↑ 1.0 1 218

Index Scan using "DataCommands_pkey" on "DataCommands" dc (cost=0.70..8.64 rows=1 width=36) (actual time=0.015..0.015 rows=1 loops=218)

  • Index Cond: ("CommandGUID" = pe."CommandGUID")
11. 2.462 7.848 ↑ 1.0 1 218

Hash Right Join (cost=3.44..4.85 rows=1 width=262) (actual time=0.028..0.036 rows=1 loops=218)

  • Hash Cond: (tc."DataTranscauseID" = det."DataTranscauseID")
12. 0.808 0.808 ↑ 1.0 29 202

Seq Scan on "RefDataTranscauses" tc (cost=0.00..1.29 rows=29 width=94) (actual time=0.001..0.004 rows=29 loops=202)

13. 0.872 4.578 ↑ 1.0 1 218

Hash (cost=3.43..3.43 rows=1 width=172) (actual time=0.021..0.021 rows=1 loops=218)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 1.792 3.706 ↑ 1.0 1 218

Hash Right Join (cost=2.17..3.43 rows=1 width=172) (actual time=0.011..0.017 rows=1 loops=218)

  • Hash Cond: (tr."DataTransactionID" = det."DataTransactionID")
15. 0.606 0.606 ↑ 1.0 18 202

Seq Scan on "RefDataTransactions" tr (cost=0.00..1.18 rows=18 width=82) (actual time=0.001..0.003 rows=18 loops=202)

16. 0.436 1.308 ↑ 1.0 1 218

Hash (cost=2.16..2.16 rows=1 width=94) (actual time=0.006..0.006 rows=1 loops=218)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
17. 0.872 0.872 ↑ 1.0 1 218

Index Scan using "DataEventTypes_idx" on "DataEventTypes" det (cost=0.14..2.16 rows=1 width=94) (actual time=0.004..0.004 rows=1 loops=218)

  • Index Cond: (dc."DataEventType" = "DataEventType")
18. 1.308 1.308 ↑ 1.0 1 218

Index Scan using "DataTaskFiles_idx2" on "DataTaskFiles" dtf (cost=0.56..8.48 rows=1 width=90) (actual time=0.006..0.006 rows=1 loops=218)

  • Index Cond: ("TaskGUID" = dc."TaskGUID")
19. 0.651 0.651 ↑ 1.0 8 217

Seq Scan on "RefDataErrors" err (cost=0.00..1.08 rows=8 width=135) (actual time=0.002..0.003 rows=8 loops=217)

20. 0.000 2.387 ↓ 0.0 0 217

Nested Loop (cost=0.84..15.09 rows=1 width=56) (actual time=0.011..0.011 rows=0 loops=217)

21. 0.434 2.387 ↓ 0.0 0 217

Nested Loop (cost=0.84..12.99 rows=1 width=20) (actual time=0.011..0.011 rows=0 loops=217)

22. 1.302 1.302 ↑ 1.0 1 217

Index Scan using "DataTasks_pkey" on "DataTasks" dt (cost=0.56..8.48 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=217)

  • Index Cond: ("TaskGUID" = dtf."TaskGUID")
23. 0.651 0.651 ↓ 0.0 0 217

Index Only Scan using "DataAgents_idx3" on "DataAgents" da (cost=0.28..4.16 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=217)

  • Index Cond: (("Region" = 99000) AND ("AgentGUID" = dt."AgentGUID"))
  • Heap Fetches: 0
24. 0.000 0.000 ↓ 0.0 0

Seq Scan on "RefFoms" reg (cost=0.00..2.09 rows=1 width=40) (never executed)

  • Filter: ("Region" = 99000)
25.          

SubPlan (forWindowAgg)

26. 0.100 2.300 ↑ 1.0 1 100

Limit (cost=1.27..58.96 rows=1 width=17) (actual time=0.022..0.023 rows=1 loops=100)

27. 0.300 2.200 ↑ 3.0 1 100

Nested Loop (cost=1.27..174.34 rows=3 width=17) (actual time=0.022..0.022 rows=1 loops=100)

28. 0.900 0.900 ↑ 1.0 1 100

Index Only Scan using "PoliciesList_idx10" on "PoliciesList" pl (cost=0.57..4.59 rows=1 width=16) (actual time=0.009..0.009 rows=1 loops=100)

  • Index Cond: (("MasterGUID" = pe."PolicyGUID") AND ("DisabledByEvent" IS NULL))
  • Heap Fetches: 6
29. 1.000 1.000 ↑ 33.0 1 100

Index Scan using "PolicyOpenData_idx5" on "PolicyOpenData" pod (cost=0.70..169.42 rows=33 width=33) (actual time=0.010..0.010 rows=1 loops=100)

  • Index Cond: ("PolicyGUID" = pl."PolicyGUID")
  • Filter: ("DisabledByEvent" IS NULL)
  • Rows Removed by Filter: 0
Planning time : 4.294 ms
Execution time : 23.673 ms