explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O5jY

Settings
# exclusive inclusive rows x rows loops node
1. 2.582 58.737 ↓ 5,950.0 5,950 1

Nested Loop (cost=0.86..12.91 rows=1 width=313) (actual time=0.067..58.737 rows=5,950 loops=1)

2. 2.605 2.605 ↓ 5,950.0 5,950 1

Index Scan using receipt_usage_entity_type_idx on receipt_usage (cost=0.43..4.45 rows=1 width=22) (actual time=0.041..2.605 rows=5,950 loops=1)

  • Index Cond: ((entity_type)::text = 'visit_type'::text)
  • Filter: ((entity_id)::text = 'i'::text)
3. 53.550 53.550 ↑ 1.0 1 5,950

Index Scan using receipts_pkey on receipts r (cost=0.43..8.45 rows=1 width=301) (actual time=0.008..0.009 rows=1 loops=5,950)

  • Index Cond: ((receipt_id)::text = (receipt_usage.receipt_id)::text)
  • Filter: is_deposit
Total runtime : 59.693 ms