explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GpB6

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

Limit (cost=2,743,358.35..2,743,418.68 rows=1 width=631) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

WindowAgg (cost=2,743,358.35..2,743,418.67 rows=1 width=631) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=2,743,358.35..2,743,358.35 rows=1 width=547) (actual rows= loops=)

  • Sort Key: pe."EventTime" DESC
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.81..2,743,358.34 rows=1 width=547) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.97..2,743,338.86 rows=1 width=523) (actual rows= loops=)

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

Nested Loop Left Join (cost=1.97..2,743,337.21 rows=1 width=433) (actual rows= loops=)

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

Nested Loop Left Join (cost=1.97..2,743,335.81 rows=1 width=355) (actual rows= loops=)

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

Nested Loop Left Join (cost=1.97..2,743,333.91 rows=1 width=265) (actual rows= loops=)

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

Nested Loop (cost=1.97..2,743,332.73 rows=1 width=134) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.39..189,377.46 rows=253 width=110) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using "DataTaskFiles_BatchFilePath_idx" on "DataTaskFiles" dtf (cost=0.69..12.71 rows=2 width=90) (actual rows= loops=)

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

Index Only Scan using "DataCommands_idx2" on "DataCommands" dc (cost=0.70..94,422.71 rows=25,966 width=36) (actual rows= loops=)

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

Index Scan using "PolicyEvents_idx3" on "PolicyEvents" pe (cost=0.57..10,094.67 rows=1 width=40) (actual rows= loops=)

  • Index Cond: ("CommandGUID" = dc."CommandGUID")
  • Filter: (("EventTime" >= '2016-01-01 00:00:00'::timestamp without time zone) AND ("EventTime" < now()) AND ((SubPlan 2) IS NULL))
14.          

SubPlan (forIndex Scan)

15. 0.000 0.000 ↓ 0.0

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

16. 0.000 0.000 ↓ 0.0

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

17. 0.000 0.000 ↓ 0.0

Index Scan using "PoliciesList_idx9" on "PoliciesList" pl_1 (cost=0.57..8.59 rows=1 width=16) (actual rows= loops=)

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

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

  • Index Cond: ("PolicyGUID" = pl_1."PolicyGUID")
  • Filter: ("DisabledByEvent" IS NULL)
19. 0.000 0.000 ↓ 0.0

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

20. 0.000 0.000 ↓ 0.0

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

21. 0.000 0.000 ↓ 0.0

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

22. 0.000 0.000 ↓ 0.0

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

23. 0.000 0.000 ↓ 0.0

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

24. 0.000 0.000 ↓ 0.0

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

25. 0.000 0.000 ↓ 0.0

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

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

Index Scan using "DataAgents_pkey" on "DataAgents" da (cost=0.28..8.05 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ("AgentGUID" = dt."AgentGUID")
  • Filter: ("Region" = 92000)
27. 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" = 92000)
28.          

SubPlan (forWindowAgg)

29. 0.000 0.000 ↓ 0.0

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

30. 0.000 0.000 ↓ 0.0

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

31. 0.000 0.000 ↓ 0.0

Index Scan using "PoliciesList_idx9" on "PoliciesList" pl (cost=0.57..8.59 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ("MasterGUID" = pe."PolicyGUID")
  • Filter: ("DisabledByEvent" IS NULL)
32. 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)