# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.039 | 10.123 | ↑ 1.0 | 100 | 1 |
→
Limit (cost=0.57..80.40 rows=100 width=4,315) (actual time=0.585..10.123 rows=100 loops=1) |
2. | 0.125 | 10.084 | ↑ 298.3 | 100 | 1 |
→
Nested Loop (cost=0.57..23,813.20 rows=29,828 width=4,315) (actual time=0.584..10.084 rows=100 loops=1)
|
3. | 2.629 | 9.659 | ↑ 33.0 | 100 | 1 |
→
Nested Loop (cost=0.29..21,989.53 rows=3,304 width=3,256) (actual time=0.566..9.659 rows=100 loops=1) |
4. | 2.338 | 2.338 | ↑ 6.4 | 4,692 | 1 |
→
Seq Scan on interpret_drafts drafts (cost=0.00..5,528.28 rows=29,828 width=2,197) (actual time=0.005..2.338 rows=4,692 loops=1) |
5. | 4.692 | 4.692 | ↓ 0.0 | 0 | 4,692 |
→
Index Scan using client_notes_clarifying_client_notes_id_index on client_notes cn (cost=0.29..0.54 rows=1 width=1,059) (actual time=0.001..0.001 rows=0 loops=4,692)
|
6. | 0.300 | 0.300 | ↑ 1.0 | 1 | 100 |
→
Index Scan using client_notes_pkey on client_notes cn2 (cost=0.29..0.54 rows=1 width=1,059) (actual time=0.002..0.003 rows=1 loops=100)
|