explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sqAe

Settings
# exclusive inclusive rows x rows loops node
1. 5.000 29.225 ↑ 3.6 4,678 1

Hash Join (cost=455.00..2,819.90 rows=16,647 width=2,408) (actual time=13.429..29.225 rows=4,678 loops=1)

  • Hash Cond: (l.leadid = a.leadid)
  • Buffers: shared hit=1,197, local read=45
2. 10.833 10.890 ↑ 1.0 16,622 1

Bitmap Heap Scan on leads_p2020_07 l (cost=13.45..1,775.05 rows=16,622 width=2,341) (actual time=0.068..10.890 rows=16,622 loops=1)

  • Recheck Cond: ((insertdate >= '2020-07-01'::date) AND (insertdate <= '2020-07-05'::date))
  • Rows Removed by Index Recheck: 1,847
  • Heap Blocks: lossy=1,152
  • Buffers: shared hit=1,154
3. 0.057 0.057 ↑ 1.5 11,520 1

Bitmap Index Scan on leads_p2020_07_leadid_insertdate_idx (cost=0.00..9.29 rows=16,960 width=0) (actual time=0.057..0.057 rows=11,520 loops=1)

  • Index Cond: ((insertdate >= '2020-07-01'::date) AND (insertdate <= '2020-07-05'::date))
  • Buffers: shared hit=2
4. 2.479 13.335 ↑ 1.0 4,684 1

Hash (cost=289.32..289.32 rows=4,684 width=75) (actual time=13.335..13.335 rows=4,684 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 520kB
  • Buffers: shared hit=43, local read=45
5. 6.291 10.856 ↑ 1.0 4,684 1

Hash Join (cost=77.94..289.32 rows=4,684 width=75) (actual time=0.488..10.856 rows=4,684 loops=1)

  • Hash Cond: (a.sourceid = s.sourceid)
  • Buffers: shared hit=43, local read=45
6. 2.885 4.261 ↑ 1.0 4,684 1

Hash Join (cost=36.19..234.91 rows=4,684 width=50) (actual time=0.172..4.261 rows=4,684 loops=1)

  • Hash Cond: (a.custid = c.custid)
  • Buffers: shared hit=26, local read=45
7. 1.235 1.235 ↑ 1.0 4,684 1

Seq Scan on _leadids a (cost=0.00..185.52 rows=4,684 width=27) (actual time=0.021..1.235 rows=4,684 loops=1)

  • Buffers: local read=45
8. 0.056 0.141 ↑ 1.1 144 1

Hash (cost=30.89..30.89 rows=163 width=27) (actual time=0.141..0.141 rows=144 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 17kB
  • Buffers: shared hit=26
9. 0.085 0.085 ↑ 1.1 144 1

Seq Scan on customers c (cost=0.00..30.89 rows=163 width=27) (actual time=0.006..0.085 rows=144 loops=1)

  • Buffers: shared hit=26
10. 0.147 0.304 ↓ 1.1 420 1

Hash (cost=28.88..28.88 rows=396 width=33) (actual time=0.304..0.304 rows=420 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 36kB
  • Buffers: shared hit=17
11. 0.157 0.157 ↓ 1.1 420 1

Seq Scan on sources s (cost=0.00..28.88 rows=396 width=33) (actual time=0.011..0.157 rows=420 loops=1)

  • Buffers: shared hit=17
Planning time : 0.782 ms
Execution time : 29.597 ms