explain.depesz.com

PostgreSQL's explain analyze made readable

Result: verE

Settings
# exclusive inclusive rows x rows loops node
1. 0.117 0.857 ↑ 2.4 26 1

Sort (cost=145.56..145.72 rows=63 width=1,248) (actual time=0.850..0.857 rows=26 loops=1)

  • Sort Key: b.pageinstance
  • Sort Method: quicksort Memory: 77kB
2. 0.035 0.740 ↑ 2.4 26 1

Hash Left Join (cost=40.16..143.68 rows=63 width=1,248) (actual time=0.427..0.740 rows=26 loops=1)

  • Hash Cond: ((a.sid = inq2.sid) AND (b.pageinstance = inq2.pageinstance))
3. 0.038 0.478 ↑ 2.4 26 1

Nested Loop (cost=0.00..102.56 rows=63 width=1,216) (actual time=0.179..0.478 rows=26 loops=1)

4. 0.006 0.284 ↓ 2.9 26 1

Append (cost=0.00..68.38 rows=9 width=1,201) (actual time=0.111..0.284 rows=26 loops=1)

5. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on rumpagetable_kohls b (cost=0.00..0.00 rows=1 width=392) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((navigationstarttime >= 178603144) AND (navigationstarttime <= 178610105) AND (sid = '767110124547343593'::numeric))
6. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on rumpagetable_2019_kohls b_1 (cost=0.00..0.00 rows=1 width=392) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((navigationstarttime >= 178603144) AND (navigationstarttime <= 178610105) AND (sid = '767110124547343593'::numeric))
7. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on rumpagetable_08_2019_kohls b_2 (cost=0.00..0.00 rows=1 width=392) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((navigationstarttime >= 178603144) AND (navigationstarttime <= 178610105) AND (sid = '767110124547343593'::numeric))
8. 0.110 0.110 ↓ 2.0 2 1

Index Scan using rumpagetable_20190829200007_kohls_sid_idx on rumpagetable_20190829200007_kohls b_3 (cost=0.42..22.13 rows=1 width=1,611) (actual time=0.109..0.110 rows=2 loops=1)

  • Index Cond: (sid = '767110124547343593'::numeric)
  • Filter: ((navigationstarttime >= 178603144) AND (navigationstarttime <= 178610105))
9. 0.038 0.038 ↓ 0.0 0 1

Index Scan using rumpagetable_20190829200007_1_kohls_sid_idx on rumpagetable_20190829200007_1_kohls b_4 (cost=0.42..21.62 rows=1 width=1,612) (actual time=0.038..0.038 rows=0 loops=1)

  • Index Cond: (sid = '767110124547343593'::numeric)
  • Filter: ((navigationstarttime >= 178603144) AND (navigationstarttime <= 178610105))
10. 0.083 0.083 ↓ 12.0 24 1

Index Scan using rumpagetable_20190830000007_kohls_sid_idx on rumpagetable_20190830000007_kohls b_5 (cost=0.42..12.50 rows=2 width=1,604) (actual time=0.051..0.083 rows=24 loops=1)

  • Index Cond: (sid = '767110124547343593'::numeric)
  • Filter: ((navigationstarttime >= 178603144) AND (navigationstarttime <= 178610105))
11. 0.047 0.047 ↓ 0.0 0 1

Index Scan using rumpagetable_20190830000008_1_kohls_sid_idx on rumpagetable_20190830000008_1_kohls b_6 (cost=0.42..12.13 rows=2 width=1,602) (actual time=0.047..0.047 rows=0 loops=1)

  • Index Cond: (sid = '767110124547343593'::numeric)
  • Filter: ((navigationstarttime >= 178603144) AND (navigationstarttime <= 178610105))
12. 0.005 0.156 ↑ 7.0 1 26

Materialize (cost=0.00..33.41 rows=7 width=15) (actual time=0.003..0.006 rows=1 loops=26)

13. 0.000 0.151 ↑ 7.0 1 1

Append (cost=0.00..33.37 rows=7 width=15) (actual time=0.058..0.151 rows=1 loops=1)

14. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on rumsessiontable_kohls a (cost=0.00..0.00 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((sessionstarttime >= 178603144) AND (sessionstarttime <= 178610105) AND (sid = '767110124547343593'::numeric))
15. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on rumsessiontable_2019_kohls a_1 (cost=0.00..0.00 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((sessionstarttime >= 178603144) AND (sessionstarttime <= 178610105) AND (sid = '767110124547343593'::numeric))
16. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on rumsessiontable_08_2019_kohls a_2 (cost=0.00..0.00 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((sessionstarttime >= 178603144) AND (sessionstarttime <= 178610105) AND (sid = '767110124547343593'::numeric))
17. 0.058 0.058 ↑ 1.0 1 1

Index Scan using rumsessiontable_20190829200007_kohls_sid_idx on rumsessiontable_20190829200007_kohls a_3 (cost=0.41..8.44 rows=1 width=12) (actual time=0.057..0.058 rows=1 loops=1)

  • Index Cond: (sid = '767110124547343593'::numeric)
  • Filter: ((sessionstarttime >= 178603144) AND (sessionstarttime <= 178610105))
18. 0.058 0.058 ↓ 0.0 0 1

Index Scan using rumsessiontable_20190829200007_1_kohls_sid_idx on rumsessiontable_20190829200007_1_kohls a_4 (cost=0.29..8.31 rows=1 width=12) (actual time=0.058..0.058 rows=0 loops=1)

  • Index Cond: (sid = '767110124547343593'::numeric)
  • Filter: ((sessionstarttime >= 178603144) AND (sessionstarttime <= 178610105))
19. 0.014 0.014 ↓ 0.0 0 1

Index Scan using rumsessiontable_20190830000007_kohls_sid_idx on rumsessiontable_20190830000007_kohls a_5 (cost=0.29..8.31 rows=1 width=12) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (sid = '767110124547343593'::numeric)
  • Filter: ((sessionstarttime >= 178603144) AND (sessionstarttime <= 178610105))
20. 0.020 0.020 ↓ 0.0 0 1

Index Scan using rumsessiontable_20190830000008_1_kohls_sid_idx on rumsessiontable_20190830000008_1_kohls a_6 (cost=0.29..8.31 rows=1 width=12) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: (sid = '767110124547343593'::numeric)
  • Filter: ((sessionstarttime >= 178603144) AND (sessionstarttime <= 178610105))
21. 0.018 0.227 ↑ 2.3 3 1

Hash (cost=40.06..40.06 rows=7 width=52) (actual time=0.227..0.227 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
22. 0.001 0.209 ↑ 2.3 3 1

Subquery Scan on inq2 (cost=39.90..40.06 rows=7 width=52) (actual time=0.208..0.209 rows=3 loops=1)

23. 0.022 0.208 ↑ 2.3 3 1

HashAggregate (cost=39.90..39.99 rows=7 width=24) (actual time=0.208..0.208 rows=3 loops=1)

  • Group Key: nveventsrecordtable_kohls.sid, nveventsrecordtable_kohls.pageinstance
24. 0.001 0.186 ↑ 2.3 3 1

Append (cost=0.00..39.81 rows=7 width=24) (actual time=0.152..0.186 rows=3 loops=1)

25. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on nveventsrecordtable_kohls (cost=0.00..0.00 rows=1 width=28) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (("timestamp" >= 178603144) AND ("timestamp" <= 178610105) AND (sid = '767110124547343593'::numeric))
26. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on nveventsrecordtable_2019_kohls (cost=0.00..0.00 rows=1 width=28) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (("timestamp" >= 178603144) AND ("timestamp" <= 178610105) AND (sid = '767110124547343593'::numeric))
27. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on nveventsrecordtable_08_2019_kohls (cost=0.00..0.00 rows=1 width=28) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (("timestamp" >= 178603144) AND ("timestamp" <= 178610105) AND (sid = '767110124547343593'::numeric))
28. 0.035 0.035 ↓ 0.0 0 1

Index Scan using nveventsrecordtable_20190829200007_kohls_sid_idx on nveventsrecordtable_20190829200007_kohls (cost=0.29..10.41 rows=1 width=21) (actual time=0.035..0.035 rows=0 loops=1)

  • Index Cond: (sid = '767110124547343593'::numeric)
  • Filter: (("timestamp" >= 178603144) AND ("timestamp" <= 178610105))
29. 0.065 0.065 ↓ 0.0 0 1

Index Scan using nveventsrecordtable_20190829200007_1_kohls_sid_idx on nveventsrecordtable_20190829200007_1_kohls (cost=0.29..10.54 rows=1 width=20) (actual time=0.065..0.065 rows=0 loops=1)

  • Index Cond: (sid = '767110124547343593'::numeric)
  • Filter: (("timestamp" >= 178603144) AND ("timestamp" <= 178610105))
30. 0.054 0.054 ↓ 3.0 3 1

Index Scan using nveventsrecordtable_20190830000007_kohls_sid_idx on nveventsrecordtable_20190830000007_kohls (cost=0.29..9.94 rows=1 width=21) (actual time=0.051..0.054 rows=3 loops=1)

  • Index Cond: (sid = '767110124547343593'::numeric)
  • Filter: (("timestamp" >= 178603144) AND ("timestamp" <= 178610105))
31. 0.031 0.031 ↓ 0.0 0 1

Index Scan using nveventsrecordtable_20190830000008_1_kohls_sid_idx on nveventsrecordtable_20190830000008_1_kohls (cost=0.29..8.92 rows=1 width=21) (actual time=0.031..0.031 rows=0 loops=1)

  • Index Cond: (sid = '767110124547343593'::numeric)
  • Filter: (("timestamp" >= 178603144) AND ("timestamp" <= 178610105))
Planning time : 39,123.932 ms
Execution time : 14.560 ms