explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ecQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 48,438.422 ↓ 44.0 44 1

Unique (cost=2,596.99..2,597.00 rows=1 width=8) (actual time=48,438.412..48,438.422 rows=44 loops=1)

2. 0.087 48,438.414 ↓ 44.0 44 1

Sort (cost=2,596.99..2,596.99 rows=1 width=8) (actual time=48,438.410..48,438.414 rows=44 loops=1)

  • Sort Key: "PersPos"."PersPos+id
  • Sort Method: quicksort Memory: 27kB
3. 3.848 48,438.327 ↓ 44.0 44 1

Nested Loop Left Join (cost=9.32..2,596.98 rows=1 width=8) (actual time=33.686..48,438.327 rows=44 loops=1)

  • Filter: (("Pos"."EntResp+PtrCustodianID" = '35126'::bigint) OR ("Pos++RspDepCsdMSL"."DRefcCode" = '35126'::bigint))
  • Rows Removed by Filter: 3159
4. 6.617 48,420.079 ↓ 2,400.0 2,400 1

Nested Loop (cost=9.04..2,596.64 rows=1 width=24) (actual time=33.668..48,420.079 rows=2,400 loops=1)

5. 11.555 48,394.174 ↓ 2,411.0 2,411 1

Nested Loop (cost=8.76..2,596.05 rows=1 width=16) (actual time=33.632..48,394.174 rows=2,411 loops=1)

6. 21.286 53.435 ↓ 289.9 16,816 1

Hash Left Join (cost=8.46..2,541.63 rows=58 width=24) (actual time=0.054..53.435 rows=16,816 loops=1)

  • Hash Cond: ("PersPos"."PtrFirstEntityID" = "Pers++NACR"."Pers+id")
  • Filter: ("Pers++NACR"."AccessBlocked" IS NULL)
7. 32.141 32.141 ↓ 1.5 16,816 1

Index Scan using "searchApplicationsActive1" on "PersPos" (cost=0.29..2,387.11 rows=11,592 width=32) (actual time=0.030..32.141 rows=16,816 loops=1)

  • Index Cond: (("EntStat+IsActive")::text = '1'::text)
  • Filter: (("EntitySubtype")::text = 'ConnectionType_Staffing'::text)
8. 0.000 0.008 ↓ 0.0 0 1

Hash (cost=8.16..8.16 rows=1 width=524) (actual time=0.008..0.008 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
9. 0.008 0.008 ↓ 0.0 0 1

Index Scan using "Pers++NACR_Pers++NACR+id" on "Pers++NACR" (cost=0.14..8.16 rows=1 width=524) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ("Pers++NACR+id" = 1)
10. 48,329.184 48,329.184 ↓ 0.0 0 16,816

Index Scan using "PersPos++StafPro_PersPos++StafPro+id" on "PersPos++StafPro" (cost=0.29..0.93 rows=1 width=16) (actual time=2.874..2.874 rows=0 loops=16,816)

  • Index Cond: ("PersPos++StafPro+id" = "PersPos"."StafPro+PtrCurrentStatusID")
  • Filter: (("PersPos"."PersPos+id" = "PersPos+id") AND ((("Status")::text = '2050'::text) OR (("SubStatus")::text = '2050'::text)))
  • Rows Removed by Filter: 11020
11. 19.288 19.288 ↑ 1.0 1 2,411

Index Scan using "Pos_Pos+id" on "Pos" (cost=0.28..0.59 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=2,411)

  • Index Cond: ("Pos+id" = "PersPos"."PtrSecondEntityID")
  • Filter: (("EntitySubtype")::text = 'PositionType_Vacancy'::text)
  • Rows Removed by Filter: 0
12. 14.400 14.400 ↑ 1.0 1 2,400

Index Scan using "Pos++RspDepCsdMSL_Pos+id" on "Pos++RspDepCsdMSL" (cost=0.28..0.33 rows=1 width=16) (actual time=0.005..0.006 rows=1 loops=2,400)

  • Index Cond: ("Pos"."Pos+id" = "Pos+id")