explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aILf

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 7,683.784 ↑ 1.0 1 1

Aggregate (cost=244.73..244.74 rows=1 width=40) (actual time=7,683.784..7,683.784 rows=1 loops=1)

2. 0.006 7,683.780 ↓ 0.0 0 1

Hash Join (cost=219.88..244.62 rows=15 width=48) (actual time=7,683.780..7,683.780 rows=0 loops=1)

  • Hash Cond: (d.attachmentid = att.id)
3. 0.018 0.018 ↑ 906.0 1 1

Seq Scan on document d (cost=0.00..20.06 rows=906 width=52) (actual time=0.018..0.018 rows=1 loops=1)

4. 0.001 7,683.756 ↓ 0.0 0 1

Hash (cost=219.69..219.69 rows=15 width=4) (actual time=7,683.756..7,683.756 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
5. 7,683.755 7,683.755 ↓ 0.0 0 1

Foreign Scan on attachment att (cost=100.00..219.69 rows=15 width=4) (actual time=7,683.755..7,683.755 rows=0 loops=1)

  • Filter: (date(dateadded) = CURRENT_DATE)
  • Rows Removed by Filter: 998765
Planning time : 0.193 ms