explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EoKwA

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=1,002.70..10,153,824.34 rows=100 width=631) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

WindowAgg (cost=1,002.70..7,582,838,900.90 rows=74,687 width=631) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,002.70..7,578,433,773.66 rows=74,687 width=547) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,001.85..7,577,302,131.49 rows=74,687 width=523) (actual rows= loops=)

  • Join Filter: (det."DataTranscauseID" = tc."DataTranscauseID")
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,001.85..7,577,270,425.67 rows=74,687 width=433) (actual rows= loops=)

  • Join Filter: (det."DataTransactionID" = tr."DataTransactionID")
6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,001.85..7,577,251,261.27 rows=74,687 width=355) (actual rows= loops=)

  • Join Filter: (dc."DataEventType" = det."DataEventType")
7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,001.85..7,577,207,453.77 rows=74,687 width=265) (actual rows= loops=)

  • Join Filter: (dc."DataErrorID" = err."DataErrorID")
8. 0.000 0.000 ↓ 0.0

Gather Merge (cost=1,001.85..7,577,198,490.23 rows=74,687 width=134) (actual rows= loops=)

  • Workers Planned: 1
9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.84..7,577,189,087.93 rows=43,934 width=134) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

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

11. 0.000 0.000 ↓ 0.0

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

12. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ("CommandGUID" = pe."CommandGUID")
13. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ("TaskGUID" = dc."TaskGUID")
  • Filter: ("BatchFilePath" ~ 'F:\\FOMS\\AutoLoad\\Gateway\\Input\\B45000-FEDEDEBE-B0BA-C0BA-B0DA-BCEBCAD00031\.dat'::text)
14. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.12 rows=8 width=135) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

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

16. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.60 rows=40 width=94) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on "DataEventTypes" det (cost=0.00..1.40 rows=40 width=94) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.27 rows=18 width=82) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

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

20. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.44 rows=29 width=94) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

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

22. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..15.14 rows=1 width=56) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..13.04 rows=1 width=20) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ("TaskGUID" = dtf."TaskGUID")
25. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (("Region" = 99000) AND ("AgentGUID" = dt."AgentGUID"))
26. 0.000 0.000 ↓ 0.0

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

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

SubPlan (forWindowAgg)

28. 0.000 0.000 ↓ 0.0

Limit (cost=1.27..58.96 rows=1 width=17) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.27..174.34 rows=3 width=17) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (("MasterGUID" = pe."PolicyGUID") AND ("DisabledByEvent" IS NULL))
31. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ("PolicyGUID" = pl."PolicyGUID")
  • Filter: ("DisabledByEvent" IS NULL)