explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6F8n : article

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.244 ↑ 1.0 20 1

Limit (cost=4.59..4.60 rows=20 width=16) (actual time=0.144..0.244 rows=20 loops=1)

2. 0.002 0.241 ↑ 251,320,089.5 20 1

Nested Loop (cost=4.59..1,094,121.67 rows=5,026,401,790 width=16) (actual time=0.143..0.241 rows=20 loops=1)

3. 0.005 0.159 ↑ 52,621.9 20 1

Merge Append (cost=4.17..87,162.33 rows=1,052,438 width=24) (actual time=0.124..0.159 rows=20 loops=1)

  • Sort Key: be.lastmodifiedtime DESC
4. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
5. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
6. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
7. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
8. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
9. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
10. 0.003 0.003 ↓ 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.003 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
11. 0.003 0.003 ↓ 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.003 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.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
14. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Index Cond: (childlevel = 1)
15. 0.002 0.002 ↓ 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.002..0.002 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.002..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. 0.057 0.057 ↑ 45,553.2 11 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.033..0.057 rows=11 loops=1)

  • Index Cond: (childlevel = 1)
19. 0.025 0.025 ↑ 50,168.8 10 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.016..0.025 rows=10 loops=1)

  • Index Cond: (childlevel = 1)
20. 0.013 0.013 ↑ 24,737.0 1 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.013..0.013 rows=1 loops=1)

  • Index Cond: (childlevel = 1)
21. 0.014 0.014 ↑ 24,912.0 1 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.014..0.014 rows=1 loops=1)

  • Index Cond: (childlevel = 1)
22. 0.002 0.002 ↓ 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.002..0.002 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.020 0.080 ↑ 2.0 1 20

Append (cost=0.42..0.94 rows=2 width=8) (actual time=0.003..0.004 rows=1 loops=20)

25. 0.030 0.030 ↑ 1.0 1 10

Index Scan using baseentity_stdopim20_pkey on baseentity_stdopim20 a (cost=0.42..0.46 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=10)

  • Index Cond: ((baseentityiid = be.baseentityiid) AND ((segmentcode)::text = 'stdopim2'::text))
  • Filter: (((catalogcode)::text = 'pim'::text) AND ((organizationcode)::text = 'stdo'::text) AND (basetype = 2))
26. 0.030 0.030 ↑ 1.0 1 10

Index Scan using baseentity_stdopim21_pkey on baseentity_stdopim21 a_1 (cost=0.42..0.46 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=10)

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