# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 3.211 | 30.422 | ↑ 109.5 | 91 | 1 |
→
Hash Join (cost=1,193.18..12,843.23 rows=9,969 width=1,297) (actual time=25.131..30.422 rows=91 loops=1)
|
2. | 2.136 | 2.211 | ↑ 109.5 | 91 | 1 |
→
Bitmap Heap Scan on permit "Extent1" (cost=258.60..9,569.82 rows=9,969 width=669) (actual time=0.086..2.211 rows=91 loops=1)
|
3. | 0.075 | 0.075 | ↑ 109.5 | 91 | 1 |
→
Bitmap Index Scan on ix_permit_approvedperiodto_permitstatustypeid (cost=0.00..256.11 rows=9,969 width=0) (actual time=0.075..0.075 rows=91 loops=1)
|
4. | 17.366 | 25.000 | ↑ 1.0 | 6,470 | 1 |
→
Hash (cost=334.70..334.70 rows=6,470 width=628) (actual time=25.000..25.000 rows=6,470 loops=1)
|
5. | 7.634 | 7.634 | ↑ 1.0 | 6,470 | 1 |
→
Seq Scan on organisation "Extent2" (cost=0.00..334.70 rows=6,470 width=628) (actual time=0.025..7.634 rows=6,470 loops=1) |
Planning time | : | 0.783 ms |
---|