explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AK3a : rbc

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 298.673 62,592.840 ↓ 3.2 708,516 1

Hash Left Join (cost=297,922.25..2,360,230.38 rows=219,365 width=260) (actual time=50,235.022..62,592.840 rows=708,516 loops=1)

  • Hash Cond: (r.categoryid = f.folderid)
2. 387.840 62,292.921 ↓ 3.2 708,516 1

Hash Left Join (cost=297,875.31..2,357,798.12 rows=219,365 width=247) (actual time=50,233.754..62,292.921 rows=708,516 loops=1)

  • Hash Cond: (i.responseid = r.id)
3. 286.912 61,891.238 ↓ 3.2 708,516 1

Hash Join (cost=296,977.59..2,352,977.20 rows=219,365 width=199) (actual time=50,219.880..61,891.238 rows=708,516 loops=1)

  • Hash Cond: (i.interfaceid = "int".id)
4. 5,737.534 61,604.172 ↓ 3.2 708,516 1

Hash Join (cost=296,962.06..2,349,945.40 rows=219,365 width=171) (actual time=50,219.695..61,604.172 rows=708,516 loops=1)

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

Seq Scan on inquiries i (cost=0.00..1,975,520.84 rows=219,365 width=134) (actual time=10,190.116..17,244.640 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,440.969 38,621.998 ↑ 1.0 7,307,924 1

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

  • Buckets: 2,048 Batches: 1,024 Memory Usage: 554kB
7. 24,181.029 24,181.029 ↑ 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=5.205..24,181.029 rows=7,307,924 loops=1)

8. 0.027 0.154 ↑ 1.1 64 1

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

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

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

10. 2.325 13.843 ↓ 1.0 5,076 1

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

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

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

12. 0.320 1.246 ↓ 1.0 1,067 1

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

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

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

Total runtime : 62,673.771 ms