explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l4FE

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

Remote Subquery Scan on all (datanode1,datanode2,datanode3,datanode4,datanode5,datanode6,datanode7,datanode8) (cost=101.57..13,555,730,459,740.51 rows=1,343,873 width=510) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Insert on hr_movingall_animation_test (cost=101.57..13,555,730,459,740.51 rows=1,343,873 width=510) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Remote Subquery Scan on all (datanode3) (cost=101.57..13,555,730,459,740.51 rows=1,343,873 width=510) (actual rows= loops=)

  • Distribute results by H: (sourceid)::text
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.57..13,555,726,911,815.79 rows=1,343,873 width=510) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.93..13,286,950,048,061.08 rows=1,343,873 width=3,009) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.93..12,883,787,440,511.95 rows=1,343,873 width=3,883) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Remote Subquery Scan on all (datanode1,datanode2,datanode3,datanode4,datanode5,datanode6,datanode7,datanode8) (cost=100.93..12,480,631,229,898.29 rows=1,343,873 width=4,757) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.93..12,480,624,832,962.81 rows=1,343,873 width=4,757) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.81..12,310,993,684,373.79 rows=1,696,274 width=3,717) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.69..12,096,863,452,423.07 rows=2,141,255 width=2,619) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.58..11,826,487,577,529.65 rows=2,703,699 width=1,523) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.46..10,738,222,745,572.69 rows=5,441,290 width=1,237) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.35..9,532,354,704,353.58 rows=12,058,414 width=832) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.23..6,703,347,703,157.11 rows=28,289,445 width=423) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Index Scan using timeseriesresult_14_12_pkey on timeseriesresult_14_12 tsr_g (cost=0.12..3,874,346,373,680.57 rows=28,289,445 width=415) (actual rows= loops=)

  • Index Cond: ((runid = 90,003) AND (catalogid = '2'::smallint) AND (ftimeseriestype = 30,148))
  • Filter: (fiqr >= '0.0400000000000000008'::double precision)
16. 0.000 0.000 ↓ 0.0

Index Only Scan using source_12_pkey on source_12 s (cost=0.12..100,002.01 rows=1 width=10) (actual rows= loops=)

  • Index Cond: ((catalogid = '2'::smallint) AND (sourceid = tsr_g.sourceid))
17. 0.000 0.000 ↓ 0.0

Index Scan using timeseriesresult_14_12_pkey on timeseriesresult_14_12 tsr_bp (cost=0.12..100,002.21 rows=1 width=415) (actual rows= loops=)

  • Index Cond: ((runid = 90,003) AND (catalogid = '2'::smallint) AND (sourceid = s.sourceid) AND (ftimeseriestype = 30,124))
18. 0.000 0.000 ↓ 0.0

Index Scan using timeseriesresult_14_12_pkey on timeseriesresult_14_12 tsr_rp (cost=0.12..100,002.21 rows=1 width=415) (actual rows= loops=)

  • Index Cond: ((runid = 90,003) AND (catalogid = '2'::smallint) AND (sourceid = s.sourceid) AND (ftimeseriestype = 30,141))
19. 0.000 0.000 ↓ 0.0

Index Scan using idx_background_hr_diagram_for_le_fixed_varpierr_13 on background_hr_diagram_for_le_fixed_varpierr_13 v (cost=0.12..100,001.26 rows=1 width=286) (actual rows= loops=)

  • Index Cond: (sourceid = s.sourceid)
20. 0.000 0.000 ↓ 0.0

Index Scan using ts_12_pkey on ts_12 ts_g (cost=0.12..100,002.21 rows=1 width=1,098) (actual rows= loops=)

  • Index Cond: ((catalogid = '2'::smallint) AND (sourceid = v.sourceid) AND (ftimeseriestype = '1'::smallint))
21. 0.000 0.000 ↓ 0.0

Index Scan using ts_12_pkey on ts_12 ts_bp (cost=0.12..100,002.21 rows=1 width=1,100) (actual rows= loops=)

  • Index Cond: ((catalogid = '2'::smallint) AND (sourceid = v.sourceid) AND (ftimeseriestype = '2'::smallint))
22. 0.000 0.000 ↓ 0.0

Index Scan using ts_12_pkey on ts_12 ts_rp (cost=0.12..100,002.21 rows=1 width=1,100) (actual rows= loops=)

  • Index Cond: ((catalogid = '2'::smallint) AND (sourceid = v.sourceid) AND (ftimeseriestype = '3'::smallint))
23. 0.000 0.000 ↓ 0.0

Result (cost=0.00..100,000.53 rows=1 width=32) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Result (cost=0.00..100,000.53 rows=1 width=32) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Function Scan on remove_filtered bp_rp (cost=0.64..100,000.64 rows=1 width=64) (actual rows= loops=)