explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PyIO

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 29,755.693 ↑ 1.0 15 1

Limit (cost=550,447.44..550,447.47 rows=15 width=341) (actual time=29,755.662..29,755.693 rows=15 loops=1)

2. 3,171.923 29,755.669 ↑ 124,262.1 15 1

Sort (cost=550,447.44..555,107.27 rows=1,863,932 width=341) (actual time=29,755.658..29,755.669 rows=15 loops=1)

  • Sort Key: consumer_getresponsepackage.timestamp_created DESC
  • Sort Method: top-N heapsort Memory: 32kB
3. 4,727.221 26,583.746 ↓ 2.0 3,731,021 1

Hash Join (cost=1.03..504,716.88 rows=1,863,932 width=341) (actual time=335.662..26,583.746 rows=3,731,021 loops=1)

  • Hash Cond: ((consumer_getresponsepackage.message_type_id)::text = (exchange_datatype.name)::text)
4. 21,856.506 21,856.506 ↓ 1.0 3,731,021 1

Seq Scan on consumer_getresponsepackage (cost=0.00..472,097.04 rows=3,727,865 width=341) (actual time=335.613..21,856.506 rows=3,731,021 loops=1)

  • Filter: (state = 1)
  • Rows Removed by Filter: 4,216,502
5. 0.006 0.019 ↑ 1.0 1 1

Hash (cost=1.02..1.02 rows=1 width=218) (actual time=0.019..0.019 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
6. 0.013 0.013 ↑ 1.0 1 1

Seq Scan on exchange_datatype (cost=0.00..1.02 rows=1 width=218) (actual time=0.012..0.013 rows=1 loops=1)

  • Filter: (NOT is_system)
  • Rows Removed by Filter: 1
Planning time : 0.259 ms
Execution time : 29,755.937 ms