explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fStD : test

Settings
# exclusive inclusive rows x rows loops node
1. 296.504 200,737.428 ↓ 3.2 708,516 1

Hash Left Join (cost=297,922.25..2,368,852.42 rows=221,467 width=260) (actual time=133,054.181..200,737.428 rows=708,516 loops=1)

  • Hash Cond: (r.categoryid = f.folderid)
2. 379.954 200,439.690 ↓ 3.2 708,516 1

Hash Left Join (cost=297,875.31..2,366,397.30 rows=221,467 width=247) (actual time=133,052.926..200,439.690 rows=708,516 loops=1)

  • Hash Cond: (i.responseid = r.id)
3. 288.295 200,047.538 ↓ 3.2 708,516 1

Hash Join (cost=296,977.59..2,361,538.79 rows=221,467 width=199) (actual time=133,040.676..200,047.538 rows=708,516 loops=1)

  • Hash Cond: (i.interfaceid = "int".id)
4. 5,991.429 199,759.017 ↓ 3.2 708,516 1

Hash Join (cost=296,962.06..2,358,478.09 rows=221,467 width=171) (actual time=133,040.381..199,759.017 rows=708,516 loops=1)

  • Hash Cond: (i.uniqueid = s.id)
5. 158,195.756 158,195.756 ↓ 4.0 886,146 1

Seq Scan on inquiries i (cost=0.00..1,983,926.86 rows=221,467 width=134) (actual time=90,463.909..158,195.756 rows=886,146 loops=1)

  • Filter: ((date(inquirydate) >= '2018-01-01'::date) AND (date(inquirydate) <= '2018-01-15'::date))
  • Rows Removed by Filter: 42,986,947
6. 14,655.552 35,571.832 ↑ 1.0 7,307,924 1

Hash (cost=141,380.47..141,380.47 rows=7,308,047 width=41) (actual time=35,571.832..35,571.832 rows=7,307,924 loops=1)

  • Buckets: 2,048 Batches: 1,024 Memory Usage: 554kB
7. 20,916.280 20,916.280 ↑ 1.0 7,307,924 1

Seq Scan on sessions s (cost=0.00..141,380.47 rows=7,308,047 width=41) (actual time=0.361..20,916.280 rows=7,307,924 loops=1)

8. 0.029 0.226 ↑ 1.1 64 1

Hash (cost=14.68..14.68 rows=68 width=36) (actual time=0.226..0.226 rows=64 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 4kB
9. 0.197 0.197 ↑ 1.1 64 1

Seq Scan on userinterfaces "int" (cost=0.00..14.68 rows=68 width=36) (actual time=0.030..0.197 rows=64 loops=1)

10. 2.230 12.198 ↓ 1.0 5,076 1

Hash (cost=835.10..835.10 rows=5,010 width=56) (actual time=12.198..12.198 rows=5,076 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 441kB
11. 9.968 9.968 ↓ 1.0 5,076 1

Seq Scan on responses r (cost=0.00..835.10 rows=5,010 width=56) (actual time=0.368..9.968 rows=5,076 loops=1)

12. 0.316 1.234 ↓ 1.0 1,067 1

Hash (cost=33.64..33.64 rows=1,064 width=21) (actual time=1.234..1.234 rows=1,067 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 58kB
13. 0.918 0.918 ↓ 1.0 1,067 1

Seq Scan on folders f (cost=0.00..33.64 rows=1,064 width=21) (actual time=0.375..0.918 rows=1,067 loops=1)

Total runtime : 200,814.721 ms