explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NyCDm : asset

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 1,924.543 ↑ 1.0 20 1

Limit (cost=4.46..4.52 rows=20 width=16) (actual time=0.357..1,924.543 rows=20 loops=1)

2. 360.318 1,924.539 ↑ 13,063,123.6 20 1

Nested Loop (cost=4.46..784,323.41 rows=261,262,471 width=16) (actual time=0.356..1,924.539 rows=20 loops=1)

3. 109.103 599.832 ↑ 1.1 964,389 1

Merge Append (cost=4.17..87,162.33 rows=1,052,438 width=24) (actual time=0.129..599.832 rows=964,389 loops=1)

  • Sort Key: be.lastmodifiedtime DESC
4. 0.011 0.011 ↓ 0.0 0 1

Index Scan using baseentity_stdooffboarding00_childlevel_lastmodifiedtime_idx on baseentity_stdooffboarding00 be (cost=0.14..2.16 rows=1 width=24) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
5. 0.004 0.004 ↓ 0.0 0 1

Index Scan using baseentity_stdooffboarding01_childlevel_lastmodifiedtime_idx on baseentity_stdooffboarding01 be_1 (cost=0.14..2.16 rows=1 width=24) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
6. 0.004 0.004 ↓ 0.0 0 1

Index Scan using baseentity_stdooffboarding20_childlevel_lastmodifiedtime_idx on baseentity_stdooffboarding20 be_2 (cost=0.14..2.16 rows=1 width=24) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
7. 0.004 0.004 ↓ 0.0 0 1

Index Scan using baseentity_stdooffboarding21_childlevel_lastmodifiedtime_idx on baseentity_stdooffboarding21 be_3 (cost=0.14..2.16 rows=1 width=24) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
8. 0.003 0.003 ↓ 0.0 0 1

Index Scan using baseentity_stdooffboarding40_childlevel_lastmodifiedtime_idx on baseentity_stdooffboarding40 be_4 (cost=0.14..2.16 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
9. 0.004 0.004 ↓ 0.0 0 1

Index Scan using baseentity_stdooffboarding41_childlevel_lastmodifiedtime_idx on baseentity_stdooffboarding41 be_5 (cost=0.14..2.16 rows=1 width=24) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
10. 0.004 0.004 ↓ 0.0 0 1

Index Scan using baseentity_stdoonboarding00_childlevel_lastmodifiedtime_idx on baseentity_stdoonboarding00 be_6 (cost=0.14..2.16 rows=1 width=24) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
11. 0.004 0.004 ↓ 0.0 0 1

Index Scan using baseentity_stdoonboarding01_childlevel_lastmodifiedtime_idx on baseentity_stdoonboarding01 be_7 (cost=0.14..2.16 rows=1 width=24) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
12. 0.003 0.003 ↓ 0.0 0 1

Index Scan using baseentity_stdoonboarding20_childlevel_lastmodifiedtime_idx on baseentity_stdoonboarding20 be_8 (cost=0.14..2.16 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
13. 0.003 0.003 ↓ 0.0 0 1

Index Scan using baseentity_stdoonboarding21_childlevel_lastmodifiedtime_idx on baseentity_stdoonboarding21 be_9 (cost=0.14..2.16 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
14. 0.003 0.003 ↓ 0.0 0 1

Index Scan using baseentity_stdoonboarding40_childlevel_lastmodifiedtime_idx on baseentity_stdoonboarding40 be_10 (cost=0.14..2.16 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
15. 0.003 0.003 ↓ 0.0 0 1

Index Scan using baseentity_stdoonboarding41_childlevel_lastmodifiedtime_idx on baseentity_stdoonboarding41 be_11 (cost=0.14..2.16 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
16. 0.003 0.003 ↓ 0.0 0 1

Index Scan using baseentity_stdopim00_childlevel_lastmodifiedtime_idx on baseentity_stdopim00 be_12 (cost=0.14..2.16 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
17. 0.003 0.003 ↓ 0.0 0 1

Index Scan using baseentity_stdopim01_childlevel_lastmodifiedtime_idx on baseentity_stdopim01 be_13 (cost=0.14..2.16 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
18. 238.741 238.741 ↑ 1.1 462,682 1

Index Scan using baseentity_stdopim20_childlevel_lastmodifiedtime_idx on baseentity_stdopim20 be_14 (cost=0.42..27,264.91 rows=501,085 width=24) (actual time=0.023..238.741 rows=462,682 loops=1)

  • Index Cond: (childlevel = 1)
19. 251.880 251.880 ↑ 1.0 501,688 1

Index Scan using baseentity_stdopim21_childlevel_lastmodifiedtime_idx on baseentity_stdopim21 be_15 (cost=0.42..27,317.53 rows=501,688 width=24) (actual time=0.015..251.880 rows=501,688 loops=1)

  • Index Cond: (childlevel = 1)
20. 0.018 0.018 ↑ 12,368.5 2 1

Index Scan using baseentity_stdopim40_childlevel_lastmodifiedtime_idx on baseentity_stdopim40 be_16 (cost=0.29..2,254.62 rows=24,737 width=24) (actual time=0.014..0.018 rows=2 loops=1)

  • Index Cond: (childlevel = 1)
21. 0.029 0.029 ↑ 1,311.2 19 1

Index Scan using baseentity_stdopim41_childlevel_lastmodifiedtime_idx on baseentity_stdopim41 be_17 (cost=0.29..2,285.25 rows=24,912 width=24) (actual time=0.013..0.029 rows=19 loops=1)

  • Index Cond: (childlevel = 1)
22. 0.003 0.003 ↓ 0.0 0 1

Index Scan using baseentity_00_childlevel_lastmodifiedtime_idx on baseentity_00 be_18 (cost=0.14..2.16 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
23. 0.002 0.002 ↓ 0.0 0 1

Index Scan using baseentity_01_childlevel_lastmodifiedtime_idx on baseentity_01 be_19 (cost=0.14..2.16 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
24. 0.000 964.389 ↓ 0.0 0 964,389

Append (cost=0.29..0.64 rows=2 width=8) (actual time=0.001..0.001 rows=0 loops=964,389)

25. 462.682 462.682 ↓ 0.0 0 462,682

Index Scan using baseentity_stdopim40_pkey on baseentity_stdopim40 a (cost=0.29..0.32 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=462,682)

  • Index Cond: ((baseentityiid = be.baseentityiid) AND ((segmentcode)::text = 'stdopim4'::text))
  • Filter: (((catalogcode)::text = 'pim'::text) AND ((organizationcode)::text = 'stdo'::text) AND (basetype = 4))
26. 501.707 501.707 ↓ 0.0 0 501,707

Index Scan using baseentity_stdopim41_pkey on baseentity_stdopim41 a_1 (cost=0.29..0.32 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=501,707)

  • Index Cond: ((baseentityiid = be.baseentityiid) AND ((segmentcode)::text = 'stdopim4'::text))" Filter: (((catalogcode)::text = 'pim'::text) AND ((organizationcode)::text = 'stdo'::text) AND (basetype = 4))